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 vote213 views1 answer
Alter table add check constraint oracle
SQL
0 vote221 views1 answer
What is initial catalog in sql connection string
SQL
3 votes201 views2 answers
How to start mysql in terminal
SQL
3 votes227 views5 answers
Foreign keys
SQL
0 vote198 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
5 votes195 views3 answers
Mysql update field from one table to another
SQL
1 vote198 views1 answer
Select not matching data from two tables
SQL
18 votes206 views6 answers
Laravel form validation
SQL
14 votes207 views3 answers
SQL trim
SQL
3 votes243 views2 answers
Truncate table
SQL