Post reply

Permissions to change/ disable SQL job schedule

  • May 5, 2010 at 4:59 am

    #224109

    I need to provide a user permissions to Permissions to change/ disable SQL job schedule .

    But I cannot provide user sysadmin role for security reasons.

    please suggest how i can provide the access without giving sysadmin rights.

    I have given access to the tables in msdb, but its of no help.

  • May 5, 2010 at 5:00 am

    #1162335

    I checked the web and there was a solution to create a proxy account, but i am not sure how. will it help?

  • May 10, 2010 at 1:39 am

    #1164864

    sqlwars (5/5/2010)

    I checked the web and there was a solution to create a proxy account, but i am not sure how. will it help?

    It will work perfectly for your requirement.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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