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 vote142 views1 answer
Sql get user account
SQL
0 vote127 views1 answer
Select value from previous row in postgresql
SQL
3 votes138 views2 answers
Postgres inner join vs join
SQL
1 vote141 views3 answers
Read all columns of a table sql
SQL
0 vote132 views1 answer
Create new table pl sql
SQL
0 vote146 views1 answer
Firebird where
SQL
0 vote171 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote135 views1 answer
Check duplicate values plsql
SQL
0 vote180 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
4 votes272 views1 answer
Oracle table statistics
SQL