Post reply

User Permissions

  • January 15, 2016 at 1:07 am

    #399576

    Hi,

    I have a sql job with 10-12 steps. The job owner is sa.

    One of the user has sql agent reader & user permissions. I don't want to give him to manage all jobs but he needs to able to manage only one job to start and stop or disable the job but the job owner should be sa.

    How to do this?

    We are using the Standard Sql 2008

  • January 15, 2016 at 1:17 am

    #1852172

    I've had this problem before. If I remember correctly, I solved it by creating stored procedures - one for each action (sp_start_job etc) and assigning the user permission to run those stored procedures.

    John

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

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