Restrict Users to Only Certain SQL Jobs

  • 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

  • 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]

Viewing 2 posts - 1 through 1 (of 1 total)

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