Role To Modify SQL Server Jobs

Question

Post reply

Role To Modify SQL Server Jobs

ajay.g

Ten Centuries

Points: 1117
More actions
December 19, 2011 at 7:24 am

#247840

Hi,
I need to assign permissions to a User to Create/Modify the jobs on a server. I've tried giving SQLAgentOperator, SQLAgentUser and other roles on MSDB. But, the user couldn't be able to create/modify the jobs. So please let me know any option which suits our requirement. It's urgent!!!
Note : I shouldn't give him SA role and he is not the owner of any job located on that server

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

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

salum SSCommitted Points: 1598 More actions · Answer 1

Have you tried this?

use msdb

EXECUTE sp_addrolemember @rolename = 'SQLAgentOperatorRole',@membername = 'username'

java[/url]

ajay.g Ten Centuries Points: 1117 More actions · Answer 2

Yes Salum,

Thats is what I've mentioned above. I've tried with all the roles from MSDB, but still unable to Modify the jobs. Could you pelase suggest how I can manage the Security in this regard. It's very urgent and critical!!!

Jeffrey Williams SSC Guru Points: 90313 More actions · Answer 3

Verify that the login and user in msdb match exactly as the AD account. This is case-sensitive and must match in order for it to work.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

hanumanth.regumadugu SSC Rookie Points: 26 More actions · Answer 4

Thank you for your response, Williams. I need to provide Modify Jobs permissions to SQL Login, not Domain or Windows level Login. So please let us know, if anything can be done in this regard.