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 vote337 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote328 views1 answer
Mysql how to reset primary key
SQL
2 votes331 views2 answers
Enable foreign key checks postgres
SQL
0 vote331 views1 answer
Get db connection detail from sql developer profile
SQL
2 votes337 views1 answer
Oracle sql merge
SQL
0 vote320 views1 answer
Mssql check if date is greater than today
SQL
1 vote363 views1 answer
Sql insert for each distinct value
SQL
0 vote346 views1 answer
Table user postgres
SQL
0 vote351 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote346 views1 answer
Ubuntu stop mysql from starting on boot
SQL