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

1 vote288 views1 answer
Join to find results not in another table
SQL
3 votes291 views1 answer
Oracle failed login attempts
SQL
1 vote299 views1 answer
Import mysql dump database command line linux
SQL
0 vote278 views1 answer
Oracle job class
SQL
0 vote284 views1 answer
Alter table myisam to innodb
SQL
2 votes328 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote304 views1 answer
Postgres set sequence value to max id
SQL
0 vote360 views1 answer
Split first name and last name in sql
SQL
0 vote277 views1 answer
Postgre admin slow
SQL
36 votes291 views3 answers
Finding duplicate column values in table with sql
SQL