Execute only privilege for Server Agent jobs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Execute only privilege for Server Agent jobs

Author

Topic

genevadba
Starting Member

1 Post

Posted - 2010-07-30 : 08:29:40

How do we ensure that users can only execute Server Agent jobs. We considered using SQLAgentUserRole but this privilege allows the users to create and execute their own jobs. I am a newbie so please be gentle.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-17 : 10:39:20

check this out...haven't tried it myself

http://www.eggheadcafe.com/software/aspnet/30519822/rights-to-execute-jobs.aspx

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources