 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / October 2005Which Server Role should I use?
Dear all, I am assigning security rights for some login ids. I would like to know if I allow some users to manage their jobs in SQL Server Agent themselves, but I don't want to give them "Server Administrators" role in Server Roles. Which Server Role should I assign to the users? Thanks a lot. Ivan Have them own the jobs if you want them to manage the jobs but not be members of sysadmins. The jobs will run under the security context of the proxy account so you will need to manage this account with whatever permissions are needed for what they are executing in their jobs. -Sue >Dear all, > [quoted text clipped - 5 lines] > >Ivan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.