July 17, 2007 at 1:46 pm
In SQL2005 Enterprise edition, is there a way to give a user only rights to access all the jobs (created by different users including maintanence jobs created by admin account) and enable or disable them and even start or stop the jobs. I don't want to give the user sysadmin (sa) rights. I want to give him only rights to manage the jobs. Thw whole idea is to employ some junior member of the team to just monitor the jobs and schedule or manually run the jobs as needed. I don't want to give the user any other rights.
I tired , all I can acheive is giving the user read only rights on msdb so he can see the jobs. But the user cannot start the job or stop it even if I give him dbwrite access to msdb.
Can anyone please point me to right direction.
Thanks
July 17, 2007 at 3:13 pm
Check out the "new" 2005 roles on msdb:
SQLAgentOperatorRole
SQLAgentUserRole
SQLAgentReaderRole
Assign the user on the one you need!
Cheers,
* Noel
July 18, 2007 at 8:19 am
Thanks...that is exactly what I am looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply