|
-
Oct 29th, 2012, 10:09 AM
#1
SSMS 2005, Sql 2000, get all database user's roles
I'm using SSMS 2005 connecting to a Sql Server 2000 server. What I'm needing to do is get all of the roles for each DB user for each database on the server. There are a few hundred users each with different roles on the different databases, it would take forever to make an Excel file to record this info if I have to open each person for each database so I'm hoping there's a quick way to do this.
Here's a screenshot of what I'm needing:
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|