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 vote181 views2 answers
Oracle chain rules
SQL
0 vote184 views1 answer
Mysql get first 2 characters of string
SQL
1 vote170 views1 answer
How to run sql script
SQL
9 votes193 views6 answers
Oracle substring
SQL
1 vote176 views1 answer
Tsql get beginning of year
SQL
0 vote178 views1 answer
Oracle select partition
SQL
3 votes174 views1 answer
Stpop start psql server
SQL
1 vote177 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote186 views1 answer
Nullif postgresql
SQL
1 vote184 views1 answer
Psql import backup file for windows
SQL