Restrict Users to Only Certain SQL Jobs

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  February 25, 2015 at 9:50 am

  #295566

  Hello Everyone

  I have never ran across this in the past that I can remember. But is there a way to restrict a user account to be able to access only certain SQL Jobs for execution? Or allow them to execute only certain SQL Jobs?

  Thanks in advance for all your comments, suggestions and hints

  Andrew SQLDBA

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  February 25, 2015 at 1:04 pm

  #1780047

  Well, by the default users does not have access to jobs at all...

  If you want to give users permission to start a certain job, look this article on my web site: http://www.sommarskog.se/grantperm.html.

  The general topic for the article is how to give users access to do things through stored procedures in a controlled manner. But two of the examples in the article is exactly how to let users start a certain job.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]