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 Veldt
Starting Member
3 Posts |
 Posted - 2006-01-03 : 04:51:17
|
| I have to list the user permissions of a number of databases. This involves a lot of databases and a lot of database roles.Is there something like sp_helprole that will give me the permissions of each role in a database? |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-03 : 05:24:43
|
| try if this helps select * from information_schema.table_privileges |
 |
|
|
Chris Veldt
Starting Member
3 Posts |
Posted - 2006-01-03 : 06:13:25
|
| Thanks, it helps.I also found a sproc sp_helprotect, which is usefull. |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-03 : 06:48:07
|
| yeah sp_helprotect is also there both are querying sysprotects table |
|
|
|
|
|
|
Listing role permissions