How to Find All Users That Have SQLAgent Permissions? 1

[JohnBates]

hi everyone,


The auditors have their microscopes out again - they want to see which logins would be able to use the SQL Agent in our SQL Server 2005 instances.

When I run this
exec sp_helpdbfixedrole 'SQLAgentOperatorRole';
it says "role not found" Am I using the wrong sp?

I'm kind of stumped on this. Checking for the sp_add_job permission might be an option. But how would I find those users?

Thanks, John

 

[JayKusch]

Of course this role is in the MSDB which I am sure you are aware of.

It is also not a DB Fixed Role but just a Role ...

SO ... you need to execute exec

   sp_helprole 'SQLAgentOperatorRole';

I would take a look at this link for additional help ...

http://msdn.microsoft.com/en-us/library/ms188283.aspx

Enjoy~


Thanks

J. Kusch