|
What is the best way to allow users to have access to their own SQL Agent jobs? (2008) I know of the msdb roles, but each user needs access only to those jobs in which he is the owner. Is there a simple way to do this? Even if it's just to allow them to run it? Thanks!!!
(comments are locked)
|
|
In the dim & distant past, when I've wanted to allow certain people access to just a couple of scheduled tasks, I've provided them with a web interface written in ASP that allows them to see the status of just those jobs to which I'm allowing them access... I have no idea if I've still got that code. hmm . . . yes a GUI seems like the only way. Maybe in the next version of SQL Server we can give access at the level - Thanks for feedback! :)
Oct 20 '10 at 03:17 PM
sqltracy
(comments are locked)
|
|
Wouldn't giving them the msdb role SQLAgentReaerRole suffice here? They could see all jobs, but can only start the jobs they actually own? Or is the requirement that they only see their jobs and no other? "Or is the requirement that they only see their jobs and no other?" - that was my reading of it...
Oct 21 '10 at 12:42 AM
ThomasRushton ♦
Difficult to be sure - "each user needs access only to those jobs in which he is the owner" Is that access in terms of controlling or also viewing?
Oct 21 '10 at 12:52 AM
WilliamD
(comments are locked)
|
