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 - 2003-10-08 : 07:50:22
|
| Malik writes "I am an oracle dba and have been called upon to gather some SQL SERVER information about my users. Basically, I was tasked to find out what user defined roles have permissions on what tables in a specific database. So in essence my report will have to show the user name, their role, name of the table that has permissions under that role and what that permission is. So it would look like this sample:Name Role Table_Name Privilege_________ __________ _______________ _________John Adams admin_group User_Table_Name C/R/U/D James Bond user_group User_Table_Name2 R/U/DI have looked in most the the popular publications but to no avail. My deadline is looming over my head and I've still not found a script that can answer this question." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-08 : 07:50:43
|
| The system procedures sp_helprole, sp_helprolemember, and sp_helprotect can provide a great deal of the information you're looking for. Books Online has more information on these procedures. |
 |
|
|
|
|
|
User Permissions