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 vote197 views1 answer
Provera dupliranih konatakata
SQL
0 vote215 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
-1 vote234 views3 answers
My sql alter table
SQL
1 vote208 views1 answer
Select random sample sql
SQL
2 votes229 views1 answer
Brew start postgres manual
SQL
0 vote239 views1 answer
Sql alter table add column if exists
SQL
0 vote242 views1 answer
Acutal month year
SQL
11 votes241 views5 answers
Update table from another table mysql
SQL
1 vote216 views1 answer
Mysql remove last empty newline
SQL
0 vote223 views1 answer
Mysql query to add hours to column in table
SQL