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 vote217 views1 answer
Python escape mysql
SQL
1 vote225 views2 answers
Pad zero sql server
SQL
0 vote224 views1 answer
Oracle for loop on list
SQL
2 votes231 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote236 views1 answer
Mysql connect bash
SQL
2 votes214 views1 answer
Update with join sql server
SQL
0 vote221 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote214 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote215 views1 answer
Sql eliminare un record
SQL
25 votes240 views1 answer
How to update an attribute in MySQL
SQL