Post reply

Assign permission to user to run a job

  • June 29, 2010 at 4:10 am

    #141140

    Hi,

    I have many jobs in my SQL Server 2005, the scenario is mentioned below: -

    job1

    job2

    job3

    job4

    I want to give only execute & view permission on job1 to user1. And rest of the jobs can be edited by the user1.

    Can you explain step by step how can I resolve this issue.

    Thanks in advance.

  • July 4, 2010 at 1:32 am

    #1188598

    hi

    I 'm in the same situation and finally i had to create a stored procedure that runs my job and i grant execute this Sp to my user . but i want the user can run the job from studio manager and can view the job history too.

    is there anybody helpus??

  • July 5, 2010 at 12:45 am

    #1188671

    jobs should be run by either job creator or service account. i dont think we can set permissions as per your requirement at job level.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • July 5, 2010 at 2:59 am

    #1188693

    You can try using Proxy account. You 'll need to create credentials and then proxy account which just have permissions mentioned by you

    Here is a link on how to do it:

    http://www.sql-server-performance.com/articles/dba/sql_server_job_proxy_account_p1.aspx

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

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

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