Post reply

Grant user access to view status of a job

  • June 29, 2012 at 1:16 am

    #263509

    Hi there,

    How do you grant a user access to view whether a job running under SQL Agent is executing or not.

    I have granted the user SQLAgentOperatorRole rghts with db_owner on msdb but the user still cannot view the job status.

    I have granted the user execute permissions to the sp: sp_get_composite_job_info in the msdb database, the user can run the SP but the information is not there.

    Can someone pls assist?

    Regards

    IC

  • June 29, 2012 at 9:35 am

    #1507182

    I just tested to make sure and people in the SQLAgentReaderRole or SQLAgentOperatorRole can see the execution status of jobs, even ones they do not own, using the Job Activity Monitor in SSMS. You certainly do not need to grant this person db_owner in the msdb database.

    What has you thinking they cannot see execution status?

    I wonder if there are any DENY permissions in place for this Server Login or Database User.

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

  • July 2, 2012 at 2:27 am

    #1507642

    Hi there,

    I have created a test user with SQLAgentOperator role rights but the user still cannot see the status in the SQL Job Activity Monitor.

    Regards

    IC

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

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