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 vote302 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
1 vote335 views1 answer
How to fetch alternate records from two tables
SQL
0 vote335 views1 answer
Rename constraint postgresql
SQL
2 votes268 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote341 views1 answer
Mysql where don't have string
SQL
0 vote325 views1 answer
Postgres sequence name
SQL
0 vote322 views1 answer
Delete data from database sqlite android
SQL
0 vote347 views1 answer
Python sql last insertend
SQL
0 vote320 views1 answer
Sql insert from excel
SQL
2 votes329 views4 answers
Mysql get all tables row count
SQL