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 vote234 views1 answer
Mysql select inside sum
SQL
7 votes215 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
2 votes232 views1 answer
Oracle log files
SQL
0 vote235 views1 answer
How to input data as id in database sql c#
SQL
0 vote195 views1 answer
Mysql find foreign key references
SQL
0 vote249 views1 answer
Alter table add check constraint oracle
SQL
2 votes256 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote221 views2 answers
Show slave status mysql
SQL
1 vote223 views1 answer
Set statiscis on in sql server
SQL
0 vote255 views1 answer
What logs are available on RDS MySQL?
SQL