Post reply

SQLAgent - Security Issue ?

  • December 6, 2005 at 6:46 am

    #111840

    Hi all

    We have users on our SQLServer with Server role of system Administrator. These users are not able to view any of the items under Enterprise Manager>Management>SQL server Agent. They are NOT able to view the Jobs, Alerts etc... Users with Local Admin rights to the server are OK...

     

    I am not the DBA, he is away. I am just the humble Data Architect who is trying to help them. Is this a weird security issue?

    We are running SQLServer 2000 SP3, Window 2003 SP1.

    Any suggestion would be of great help.

     

  • December 6, 2005 at 7:32 am

    #607926

    Users who need to view agent information like jobs and schedules can be added to a role within the MSDB database called TragetServersRole.  This should allow them to view the above mentioned information.

  • December 6, 2005 at 7:53 am

    #607934

    If they are system administrators, they should be able to view everything.

    If they are running EM, go to Tools, then Query Analyzer and startup a profile on that tool. SELECT user_name() and see if Sa comes back.

    If not, they are not mapped as system administrators.

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

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