Home Forums SQL Server 7,2000 SQL Server Agent grant permissions to view SQL Server agent. RE: grant permissions to view SQL Server agent.

  • November 14, 2012 at 5:24 pm

    #1559190

    Grant the SQLAgentReaderRole and set the job owner to a different user.

    That way, users can only see the jobs, but cannot start/stop/modify them.

    -- Gianluca Sartori