Home Forums SQL Server 2005 Administering minimum roles (server/database) should be given to a user to run jobs RE: minimum roles (server/database) should be given to a user to run jobs

  • luckysql.kinda (9/23/2009)


    Yes this user should be able to run only sql jobs (any jobs; not only his own) and nothing else.

    -lk

    Could be interesting, you need to give him SQLAgentoperatorRole to allow him to execute any sql jobs on that server, are you also aware that if you give him that role, he will able to also do the following.

    Create/modify/delete his own jobs

    enable/disable any jobs

    view properties on any job

    edit any jobs that he owns/creates

    start and stop any job

    view job history for all jobs

    delete job history for all jobs

    It is the most priviledged out of all the job roles and implies a lot of trust, you can in theory do it by granting access to certain stored procedures to allow starting the jobs, but that is not that easy and can be a pain to troubleshoot to get exactly right.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]