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 vote138 views1 answer
Importance of comment in mysql
SQL
0 vote195 views2 answers
SQL BULK INSERT
SQL
0 vote108 views1 answer
Check if due date is less than todays date sql
SQL
0 vote156 views1 answer
Get null value in sql
SQL
0 vote146 views1 answer
Grant privileges of databse to user
SQL
0 vote172 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote155 views2 answers
How to create a table from another table in sql derby
SQL
2 votes153 views2 answers
Mamp connect mysql terminal
SQL
6 votes143 views4 answers
Delete table sqlite
SQL
0 vote164 views1 answer
Postgresql on conflict pair
SQL