Post reply

What privilege should I grant for a user to view jobs?

  • July 9, 2010 at 2:22 pm

    #237573

    Many thanks for any input in advance.

  • July 9, 2010 at 2:33 pm

    #1191022

    From SQL2005 on a number of new databases roles were added to msdb to grant more granular roles to users in SQLAgent.

    SQLagentReaderrole should be what you want.

    ---------------------------------------------------------------------

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

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