Post reply

Give User Access to edit SQL Job

  • April 10, 2012 at 10:29 am

    #254645

    Is there are way to give a user access to edit a particular SQL Job?

  • April 10, 2012 at 12:03 pm

    #1471402

    You could add them to the msdb Database Role SQLAgentUserRole and them make them the job owner of any jobs you want them to be able to modify.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 10, 2012 at 12:39 pm

    #1471425

    That worked good, thanks !!

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

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