Post reply

Provide access to a group of users to modify sql server agent jobs without granting sql server admin role

  • September 23, 2016 at 11:41 am

    #330447

    Hi Guys,

    Is there an alternate way to provide access to a group of users to modify sql server agent jobs without granting sql server admin role.

    Many thanks in advance.

  • September 23, 2016 at 11:50 am

    #1902881

    Check out this page for information on SQL Agent roles defined in the msdb database:

    https://msdn.microsoft.com/en-us/library/ms188283.aspx

  • September 23, 2016 at 11:57 am

    #1902884

    I'm aware that with the following roles the user is not able to modify jobs unless the user owns the jobs or the user has SA rights.

    My requirement is to "provide access to a group of users to modify few/all sql server agent jobs without granting sql server admin role"

    SQLAgentUserRole

    •SQLAgentReaderRole

    •SQLAgentOperatorRole

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

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