question

sqltracy avatar image
sqltracy asked

SQL Agent Job access

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!!!
sql-agentaccessownership
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqltracy avatar image sqltracy commented ·
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! :)
0 Likes 0 ·
WilliamD avatar image
WilliamD answered
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?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
"Or is the requirement that they only see their jobs and no other?" - that was my reading of it...
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
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?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.