SQL Server Performance Forum – Threads Archive
Permissions for DTS packagesHi 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.