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 |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2011-07-26 : 10:45:45
|
| Our security permissions are a bit of a mess so I want to create a script to run on each server to find out what permissons each user (principal) has.I can get the principals I want to look at from sys.server_principals, but then I'm not sure which other tables/views I should be looking at to find which databases they are mapped to and their server role.I'd like to write the script myself so I just need some pointers to get me started.Thanks in advance!Junior DBA learning the ropes |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-07-27 : 09:03:44
|
| I think I might be able to figure this out. Looks like sys.server_principals is a good basis to get most of the information I want.Junior DBA learning the ropes |
 |
|
|
|
|
|
SQL to list security permissions