Disable user access to create SQL Server Jobs

Question

Post reply

Disable user access to create SQL Server Jobs

thuybui-791943

Old Hand

Points: 311
More actions
January 7, 2009 at 12:44 pm

#127868

How do I disable user access to create SQL Server Jobs? I want the user to be able to view the jobs but not creating new one.
Thanks,
Thuy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

See if the default roles meets ur requirement:http://technet.microsoft.com/en-us/library/ms188283.aspx

Or you can explicitly deny access on sp_add_job stored procedure for that particular user.

MJ

noeld SSC Guru Points: 96590 More actions · Answer 2

noeld

SSC Guru

Points: 96590

January 7, 2009 at 1:08 pm

#922860

make them part of SQLAgentReaderRole

* Noel

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

noeld (1/7/2009)
make them part of SQLAgentReaderRole

You also would need to remove them from the existing role that is providing them the rights currently. Don't forget to add the login as a user to msdb which is where the SQLAgentReaderRole exists. Then you add the database role to the user account.