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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2010-07-06 : 10:36:30
|
| Hi all,I have a user defined database role on a database, and I need to know exactly what permissions this role has in the database.I know in SQL 2000 you could click on the role in enterprise manager and then press the permissions button to view permissions, however this does not seem to exist in SQL 2005 Management studio.Thanks, |
|
|
beniaminus
Starting Member
21 Posts |
Posted - 2010-07-06 : 11:15:50
|
| Goto the database and look in the Security Folder. There you will find a Roles folder. Expand it, right click on the role you want to view and click Properties. You can then click on the Securables page and view specific permissions on each object in the database.Hope this helps,Ben :) |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2010-07-06 : 11:59:08
|
| Thanks for your reply, the securables page was completely empty. However I did manage to get the permissions by running sp_helprotect. |
|
|
|
|
|
|
User defined database role permissions