Sql check roles

USE master  
GO  
SELECT DP1.name AS DatabaseRoleName,   
   isnull (DP2.name, 'No members') AS DatabaseUserName   
 FROM sys.database_role_members AS DRM  
 RIGHT OUTER JOIN sys.database_principals AS DP1  
   ON DRM.role_principal_id = DP1.principal_id  
 LEFT OUTER JOIN sys.database_principals AS DP2  
   ON DRM.member_principal_id = DP2.principal_id  
WHERE DP1.type = 'R'
ORDER BY DP1.name;

Similar codes

0 vote339 views1 answer
Dual in db2
SQL
0 vote296 views2 answers
MySQL top percent
SQL
0 vote337 views1 answer
Amount of entries in a table psql
SQL
1 vote337 views1 answer
Alter constraint in sql
SQL
1 vote293 views1 answer
Nested if in mysql
SQL
0 vote332 views1 answer
Creating h2 database in relative directory eclopse
SQL
3 votes496 views6 answers
Sql unique select
SQL
0 vote312 views1 answer
WHERE not regex in SQL
SQL
0 vote380 views1 answer
Split first name and last name in sql
SQL
0 vote319 views1 answer
Mysql grant grant option
SQL