April 26, 2012 at 4:00 am
How to give permission to a paticular user to view and modify to a particular user Sql job only.
I.e user want to view and modify his Sql jobs only.
Can any one help me out here.
How can i grant permission..
April 26, 2012 at 4:04 am
take a look here http://msdn.microsoft.com/en-us/library/ms188283.aspx this will detail which one of the three roles to grant the user in to within the MSDB database, then set the owner of the job to the account the user uses.
April 26, 2012 at 4:50 am
Sorry Small correction.
User what to see only his jobs and he should not have any edit permission or modify permission of his jobs
.He should have only read permission on that job(so that he veiw job deatis,job history).
April 26, 2012 at 4:59 am
you might want to look at creaing custom views in msdb which the user can then call which filters on jobs owned by the users SID
even if you grant to lowest role of SQLAgentUserRole the user will be able to modify, enable/disable, start/stop any job which is owned by them
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply