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 vote364 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote389 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote411 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
9 votes389 views3 answers
Mysql run sql file
SQL
0 vote372 views1 answer
DATEDIFF minute postgres
SQL
5 votes358 views1 answer
Sql select ciunt
SQL
8 votes403 views1 answer
Mysql limit rows
SQL
0 vote343 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote362 views3 answers
Insert or ignore postgres
SQL
11 votes361 views1 answer
Sql insert multiple rows from select
SQL