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

3 votes154 views2 answers
How to start postgresql on windows
SQL
0 vote157 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote156 views1 answer
Plpgsql if statement
SQL
1 vote175 views1 answer
Mysql return text after a final full stop
SQL
0 vote158 views1 answer
Sqlalchemy get schema from database
SQL
1 vote204 views1 answer
Find size of all DB's postgres
SQL
20 votes147 views3 answers
SQL query rename table
SQL
0 vote161 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote210 views1 answer
Jpa generationtype sequence mysql
SQL
-2 votes156 views1 answer
Mysql see users and passwords
SQL