Post reply

Sql agent job

  • December 23, 2008 at 6:55 pm

    #126678

    if a user created a job who is not a sysadmin, as a sysadmin can i give prevelages to another user so that he can edit the job thoug he is not the owner? if so how can i do it.

    thanks

  • December 23, 2008 at 7:19 pm

    #917190

    There are three database roles in msdb database.

    SQLAgentUser

    SQLAgentReader

    SQLAgentOperator.

    A user if he is not a sysadmin must be a member of either of the roles under msdb. SQLAgentOperator role gives users complete access to Sql Agent.

    Regards,

    Sam.

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

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