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 vote179 views1 answer
Change permission to database mysql
SQL
0 vote192 views1 answer
Check if database exists sql
SQL
0 vote181 views1 answer
Sql server alter table column nullable
SQL
0 vote191 views1 answer
Get rows from 1 table with other table empty mysql
SQL
4 votes182 views4 answers
Sqlite describe table
SQL
0 vote248 views1 answer
Sql count matching group by
SQL
0 vote206 views1 answer
Mysql utc timestamp
SQL
0 vote227 views1 answer
Sql server datetime
SQL
2 votes201 views3 answers
Row number mysql
SQL
0 vote171 views1 answer
Prepared statement mysql java delete selected rows
SQL