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

11 votes103 views6 answers
Distinct sql
SQL
1 vote113 views1 answer
How to print longest name in sql
SQL
18 votes112 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote102 views4 answers
Mysql on kubernetes
SQL
0 vote102 views1 answer
Vowels in sql
SQL
0 vote135 views1 answer
Login failed for user sql server
SQL
0 vote99 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote104 views1 answer
Mod in sql
SQL
0 vote98 views1 answer
Uuid sqlalcomany
SQL
0 vote118 views2 answers
Impala rename column name
SQL