January 8, 2014 at 3:40 pm
the user is having sqlagent opertor role permissions , even though the user is not able to edit or modify the jobs in sql ?
How to resolve the issue
January 8, 2014 at 5:35 pm
SQLAgentOperatorRole members change edit/modify "owned" jobs only.
January 8, 2014 at 5:39 pm
but the user is not edit or modify the job steps even though he is having permissions in msdb..sqlagent operator role.
what is the reason ? how to solve this ?
January 8, 2014 at 5:52 pm
The reason is, that user is not the owner of the job or not member of sysadmin server role.
Just SQLAgentOperatorRole membership is not enough to edit/modify a job.
Only job owner or sysadmin can edit/modify jobs.
To solve this you can change the ownership of the job to the user.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply