SSIS Permissions issue

Question

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!

Answer 1

Default database roles mentioned in the question allows users to run the package. The work around is to create new role in MSDB and assign the users privileages to execute the stored procedure "sp_dts_getpackage".