MS SQL Server - Removing operators from System administrator Role

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Removing operators from System administrator Role

Tinchos

2005-07-28, 9:23 am

Hi List!

I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
take them off, but the people said me that they need to monitor a lot of jobs
running on this server, so what priviledges does i need to grant them to allo
to see the results of this jobs?

Jens Süßmeyer

2005-07-28, 11:26 am

http://groups.google.de/group/micro...371c08
60

http://groups.google.de/group/micro...6aa1b4
e1

HTH, Jens Suessmeyer.

"Tinchos" wrote:

> Hi List!
>
> I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
> take them off, but the people said me that they need to monitor a lot of jobs
> running on this server, so what priviledges does i need to grant them to allo
> to see the results of this jobs?
>

Sponsored Links