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 vote259 views1 answer
Sql sort column by date
SQL
0 vote268 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote260 views1 answer
Horizontal join sqlite
SQL
0 vote265 views1 answer
Mysql order by where condition sub query
SQL
11 votes275 views1 answer
Oracle insert into where
SQL
-1 vote272 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote304 views1 answer
Finding leap year in sql
SQL
4 votes254 views1 answer
Check database name postgresql
SQL
0 vote255 views1 answer
Initcap in sql
SQL
1 vote254 views2 answers
Limit sqlserver
SQL