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 |
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
 Posted - 2011-07-06 : 10:01:43
|
| I have One Server with 3 instanceinstance A,B and C; Each instance having multiple databases exampleinstance A having 15 databasesinstance B having 20 databasesinstance C having 10 databasesand I have 600 Users (windows authentication)Now I need to know instance A database users wise and permissions like (read,Write...database permission)similarly I need to know instance B users and permissionsSimilarly I need to know instance C usersOutput like Database_name, User_name,read_permission,write_Per,....testA,xxx, yes,no,....tersA,yyy, yes,yes....In Love... With Me! |
|
|
Asif5566
Starting Member
9 Posts |
Posted - 2011-07-06 : 12:08:10
|
quote:
Originally posted by raghuveer125
I have One Server with 3 instanceinstance A,B and C; Each instance having multiple databases exampleinstance A having 15 databasesinstance B having 20 databasesinstance C having 10 databasesand I have 600 Users (windows authentication)Now I need to know instance A database users wise and permissions like (read,Write...database permission)similarly I need to know instance B users and permissionsSimilarly I need to know instance C usersOutput like Database_name, User_name,read_permission,write_Per,....testA,xxx, yes,no,....tersA,yyy, yes,yes....In Love... With Me!
Interesting Question ... Even though I wont claim any authority on the topic but the following links might be helpful ...http://www.mssqltips.com/tip.asp?tip=1718http://blog.mrlacey.co.uk/2007/06/checking-database-permissions-in-sql.html |
 |
|
|
|
|
|
|
|
Database User name and permissions