February 18, 2011 at 2:37 pm
I need to give execute permission for only one particular job for two different users. I could make the owner of a job one of the user but there are two users. I tried creating roles under msdb but i couldnt find the job names as securables? Is there a way i can do it?
February 21, 2011 at 10:30 am
?
February 21, 2011 at 11:26 am
sqldba_icon (2/18/2011)
I need to give execute permission for only one particular job for two different users. I could make the owner of a job one of the user but there are two users. I tried creating roles under msdb but i couldnt find the job names as securables? Is there a way i can do it?
If your jobs are not executing T-SQL then you could create Agent proxies from a system admin account to run the Jobs. I think the proxies cannot be used to run T-SQL scripts but all other tasks will run with proxies. Check the link below for details.
http://msdn.microsoft.com/en-us/library/ms190698.aspx
Kind regards,
Gift Peddie
February 21, 2011 at 3:24 pm
That might work, but might also break the access of others.Thanks
February 22, 2011 at 1:40 pm
sqldba_icon (2/21/2011)
That might work, but might also break the access of others.Thanks
The proxy account is security context delegation with some restriction so I am not sure what you mean by breaking access of others.
That is the person with the proxy permission can use the Agent automation subsystem without actual System Admin permissions.
Kind regards,
Gift Peddie
February 23, 2011 at 9:11 am
alright let me try that. Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply