patternMinor
Can I delegate SQL Agent rights without granting sysadmin rights?
Viewed 0 times
canwithoutsqlagentgrantingsysadminrightsdelegate
Problem
I'd like to give a user the ability to administer SQL Agent jobs. According to the doc page, I can do this by granting the "appropriate" roles on msdb. I've granted all three SQLAgent% roles, but the user gets this error when (as a test) trying to rename a job:
This question is similar, but no answer there addresses SQL Agent. Is the sysadmin role the only solution, in MS SQL 2K8?
Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
(Microsoft SQL Server, Error: 14525)This question is similar, but no answer there addresses SQL Agent. Is the sysadmin role the only solution, in MS SQL 2K8?
Solution
Unfortunately, administration of Agent jobs can currently only be done by members of the
sysadmin role. The relevant documentation is found on MSDN. You'll note that the three Agent roles (User, Reader, and Operator) have different levels, but ultimately a user without sysadmin can only edit/manage jobs that user owns and not jobs created by other users.Context
StackExchange Database Administrators Q#39592, answer score: 5
Revisions (0)
No revisions yet.