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 vote256 views3 answers
Classement rang mysql 7
SQL
0 vote191 views1 answer
Create function syntax sql server
SQL
1 vote221 views1 answer
Oracle select row max date
SQL
18 votes190 views3 answers
Mysql current date
SQL
0 vote219 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
8 votes191 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote191 views1 answer
Access the postgres psql
SQL
0 vote212 views1 answer
Postgresql regular expression special characters
SQL
1 vote235 views1 answer
Sql string function update replace
SQL
0 vote183 views1 answer
Postgres select except
SQL