Hello. In SQL 2005 Enterprise I've added a user to SqlAgentUseRole in msdb. They can create a job but cannot later go back and edit a step; everything is grayed out. I saw this article about an error in SQL 2008 that's been fixed in 2008 CU3.
I'm not sure if this is the same issue. If it's a different issue, does anyone know if it's been addressed in SQL 2012?
- Moved by ArthurZMVP Thursday, January 09, 2014 8:39 PM
This issue is due to limited rights on SqlAgentUseRole in msdb, user can Create/modify/delete only owned jobs
As mentioned in below link:
Further, provide access on some msdb procedures as discussed in below thread:
Please click the Mark as answer button and vote as helpful if this reply solves your problem
- Proposed as answer by Sofiya LiMicrosoft contingent staff, Moderator Friday, January 10, 2014 7:35 AM
Neha, thanks, but that is not working. We're talking about a user in SQLAgentUserRole trying to update a job that they created and own. Something they should be able to do. I tried giving this user Exec access to those msdb procs to no avail. It looks like the thread you're showing has someone trying to do some kind of hybrid rights; somewhere in between AgentReader and AgentOperator.