Hi, How to revoke 1. Execute all packages and 2. Execute all packages in SQL Server Agent. from db_dtsoperator. I am giving permission to user to just see listing of packages, export packages. Thanks

I am thinking you need to approach this from the package side. Specifically, if you implement Package Protection Level (http://msdn.microsoft.com/en-us/library/ms141747.aspx) EncryptAllWithPassword without knowing the package password a user would not be able to execute it, but will be able to see it.Arthur My Blog

I'm pretty sure that if EncryptAllWithPassword is used, users won't be able to open packages they export. The OP needs to advise whether his users need the ability to open the packages they export. If not, your solution would work Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Hi DBA_Leaner, If the other roles like Windows administrators and db_dtsltduser are checked , Windows administrators can View execution details of all running packages and stop. and db_dtsltduser can run his own packages. You could try to use any one of them and assing them to users. http://msdn.microsoft.com/en-us/library/ms141053(v=sql.90).aspx . I could not understand how Windows administrators can only View execution details of all running packages and stop. ? Happy to help! Thanks. Regards and good Wishes, Deepak.

Thans all for their time. client requirement is: Users should able to export package and be able to open it in sql server integration services development studio, just to see package. They should not able to execute, delete, import package in production. I am thinking about db_dtsoperator role in msdb. That gives user to export all packages but also gives rights to execute all packages. In db_dtsoperator role there are some packages which contrll all access. I don't know which package control privileges of execute a ssis package. If anyone knows, please help me. Thanks

Anyone else knows: how to grant user permission so that he can export package to ssis development studio just to view package but should not able to do any other thing such as execute, import, delete etc.

Seems this can not be done. A use who has access to Export a package probably has access to execute it.http://www.rad.pasfu.com

Thanks for reply. Does any one know which stored procedure in db_dtsoperator grants rights to execute package? Any help will be appreciated. Thanks