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

11 votes249 views3 answers
Pl sql example
SQL
0 vote204 views1 answer
Gcloud sql list databases
SQL
1 vote183 views1 answer
Oracle select first result
SQL
0 vote200 views3 answers
Query string not ending with with vowels
SQL
1 vote240 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote203 views1 answer
Best sql course
SQL
0 vote175 views1 answer
Inser into example
SQL
5 votes209 views1 answer
Oracle list packages
SQL
0 vote278 views1 answer
Install ms sql server management studio
SQL
6 votes194 views3 answers
Mysql first day of year
SQL