SQL Server Performance Forum – Threads Archive

Permissions for DTS packages

Hi there, I’d like to know what fixed server roles or database roles are required to set in order to allow a user to do the followings: 1. update and exec packages,
2. update views, and
3. view SQL Agent jobs of scheduled running packages
Thanks for your input.

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;282463 to start with. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>