Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raul11
Starting Member
48 Posts |
 Posted - 2011-10-14 : 04:57:36
|
| I have a login S12345. I want to know the following...What are the previliges associated with this what jobs are run with this on what servers is this locatedIS there any automated script/s which will help me get thisRegards |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-10-14 : 06:46:53
|
| I'm not sure there is an easy way to automate this.If you wanted to check multiple servers you'd have to use something like Powershell from a central location to look at each SQL Server instance. It isn't that hard to script the users on the server and the server roles they belong to, so you could have a look into this. You could start with looking into the syslogins table in the masterdatabase and going from there. I wrote a script to do this but I seem to have misplaced it!For job information you'd have to look in the MSDB database and look at jobs where the user is the owner.Hopefully this info gives you a starting point.----------------------------Junior DBA learning the ropes |
 |
|
|
raul11
Starting Member
48 Posts |
Posted - 2011-10-14 : 07:23:53
|
| thnx for your help |
|
|
|
|
|
|
previliges