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 vote132 views1 answer
Foreign key type uniqu mysql
SQL
1 vote145 views1 answer
Retrieve meaning
SQL
0 vote123 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote127 views1 answer
Equi joins in oracle
SQL
0 vote129 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote127 views1 answer
Strat with in sql
SQL
0 vote154 views1 answer
How to define a non primary composite key in sql
SQL
1 vote130 views1 answer
Oracle undo usage per session
SQL
1 vote157 views1 answer
Psql search table
SQL
2 votes163 views1 answer
Sql server: select column values as comma separated string
SQL