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 vote143 views1 answer
Procedures sql insert mysql
SQL
8 votes149 views2 answers
Select current_timestamp - interval '3 days';
SQL
4 votes131 views2 answers
Sql table
SQL
0 vote142 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
18 votes137 views4 answers
Mysql current date between two dates
SQL
1 vote150 views1 answer
Sqlite3 read only
SQL
3 votes130 views1 answer
Index using in query plsql
SQL
12 votes143 views1 answer
Script to add new column in table sql
SQL
18 votes136 views3 answers
Mysql number format
SQL
1 vote151 views1 answer
Delete specific row in sql
SQL