SSIS Permissions issue

Posted by Dave on Stack Overflow See other posts from Stack Overflow or by Dave
Published on 2010-04-14T20:10:39Z Indexed on 2010/04/14 20:13 UTC
Read the original article Hit count: 199

Filed under:
|

Hi All,

How can we set permissions for users to only allow them to download SSIS packages from the production server and but deny them permissions to run any package in the Server.

http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx

If i assign users to any of the DB roles db_dtsadmin, db_dtsltduser, and db_dtsoperator they will automatically have permission to run the package.

Appreciate your inputs.

Thanks!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about ssis