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 |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2010-08-16 : 15:51:14
|
| Hi all, Just wanted to know if there is a sql query to list the permissions assigned for an application role? I tried sys.database_permissions, it didn't have.Thank you |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-17 : 08:34:38
|
| what type of permission? I see the permissions on the sys view...select d.name,object_name(major_id),* from sys.database_permissions pjoin sys.database_principals d on p.grantee_principal_id=d.principal_idwhere d.type='r' and d.is_fixed_role=0 and name <>'public'--------------------keeping it simple... |
 |
|
|
|
|
|
view