Post reply

Backup Admin

  • June 12, 2009 at 9:06 am

    #205465

    Hello,

    I would like to give a user permission to VIEW JOB HISTORY.

    I would like to give another user permission to VIEW JOB HISTORY and also MODIFY JOBS.

    What is the minimum security I can provide to allow this? I do not see a "Backup Admin" role.

    ** SQL 2005 Enterprise

    Thanks!

    Terry

    A great day starts with a great attitude

  • June 12, 2009 at 10:58 am

    #1008815

    You should look at SQL Agent fixed database roles. SQLAgentReaderRole might suffice for the user you want to view job history. http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

    I don't think there's a way to allow a user to modify jobs he/she doesn't own unless they're members of sysadmin.

    Greg

  • June 12, 2009 at 12:16 pm

    #1008841

    That did it. I looked all over for roles but never looked in the msdb database.

    Thanks!

    A great day starts with a great attitude

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

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