Post reply

SQL Server Agent access for non sa user

  • June 11, 2008 at 3:26 am

    #192195

    I want to allow someone to view the jobs on the sql server but not to be able to create, edit or delete them.

    more importantly I don't want them to have sa access on the machine just on account of the SQL Agent requirement.

    In other words - Firstly I just want them to have access to SQL Agent and then if possible I want the to have read only access but also the ability to start, stop and restart jobs - i.e. tune their access.

    Any ideas welcome

    thanks

    Dave

  • June 11, 2008 at 9:25 am

    #827349

    Have you looked at the SQL Server Agent fixed database roles in msdb? Although I haven't tried it, it sounds like the SQLAgentOperatorRole would fit your needs if you modifed it so it couldn't create and delete jobs. You'd just have to remove a few execute permissions.

    Greg

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

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