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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-04 : 08:45:31
|
| Denise writes "I would like to run a SQL query to list all the database users and the privileges of each (if they belong to a role, include the privileges of that role), are there system tables, views, procedures I can use to determine this?Thanks,Denise McMillanMGHS Database Administration" |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2005-01-07 : 06:38:37
|
| Check the system tables - sysusers, sysmembers & syspermissions in BOL. This should help you to build a query.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
 |
|
|
|
|
|
User Privileges