How can we give view right on SQL Job ?

Question

question

basit 1 asked Oct 7, '11

How can we give view right on SQL Job ?

Hi All, How can we give view right on SQL Job. We have 100 Job in our SQL Server , I want to give view right to some user to see the job. I have given SQLAgentReaderRole permissions to the user. After this user can view all the job and getting option to execute the job also. The job are owned by some other user. So the user having this role can execute\Run the job which are owned by some other user. Can a member of SQLAgentReaderRole execute the job if he is not the owner of that job. Thanks Basit

sql job

1

10 |1200

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

DaniSQL commented · Oct 11, 2011 at 08:13 AM

I had issue trying to do this a while back and I dont remember what exactly it was but I remember there was a bug when you use windows authentication along with these SQLAgentRole's; but the roles behave as expected for SQL logins.

0 ·

Answer 1 · 2011-10-07T10:56:54Z

KenJ answered Oct 7, '11

members of the SQLAgentReaderRole can only execute jobs which they own. SQL Server Agent Fixed Database Roles - http://msdn.microsoft.com/en-us/library/ms188283.aspx A little more information based on comments... The start job options are enabled but when a member of the SQLAgentReaderRole actually tries to start a job, they get a failure message: "Only owner of a job or members of role sysadmin or SQLAgentOperatorRole can start and stop the job" ![alt text][1] [1]: /upfiles/SQLAgentReaderRoleCantStartJob_1.png

2

10 |1200

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

KenJ commented · Oct 07, 2011 at 11:11 AM

Does the job run when they click start? Are you using proxies to which the user might have access?

2 ·

basit 1 commented · Oct 07, 2011 at 11:05 AM

But the user are getting the option to start job

0 ·

question