April 10, 2012 at 5:53 pm
I am working as sql DBA, i gave access to one user to dev server. He need to run only jobs. So i gave him access with roles ssis operator , data reader, SQlagent operator and public on that server. he is not able to see the jobs. Will any one suggest me with this issue.
April 11, 2012 at 9:22 am
Based on the documentation it looks like you have added the user to the necessary roles.
What happens if you do this:
USE msdb
GO
Execute AS USER = 'low_privileged_user'
SELECT * FROM dbo.sysjobs AS S
REVERT
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 11, 2012 at 9:43 am
Did he by chance refresh ssms after you granted those permissions?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 12, 2012 at 3:47 pm
with those permissions user can see the jobs that he owns.
April 12, 2012 at 4:05 pm
EvilDba (4/12/2012)
with those permissions user can see the jobs that he owns.
That's not accurate. SQLAgentOperator can view ALL jobs, but can only modify the jobs that the user owns. See the SQLAgentOperator role permissions table at the end of this BOL article, http://msdn.microsoft.com/en-us/library/ms188283.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply