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 vote341 views1 answer
Mysql order by on condition
SQL
0 vote342 views1 answer
Oracle SQL join three tables and group by column
SQL
2 votes318 views1 answer
How to select first row of database sql
SQL
0 vote455 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote318 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote342 views1 answer
ORA-00942
SQL
8 votes351 views5 answers
Grant permission in postgres
SQL
0 vote332 views1 answer
Php delete database
SQL
0 vote357 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote357 views1 answer
Supprimer les valeur d'une table mysql
SQL