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 vote117 views2 answers
Oracle difference between two dates in seconds
SQL
3 votes207 views2 answers
Savepoint in sql
SQL
0 vote119 views1 answer
Import big data to mysql
SQL
2 votes121 views2 answers
Mysql all columns
SQL
0 vote128 views1 answer
Change role postgres
SQL
7 votes136 views3 answers
Sql set
SQL
0 vote118 views2 answers
Mysql password error create datbase
SQL
31 votes121 views1 answer
Postgresql add column with constraint
SQL
0 vote211 views2 answers
Execute stored procedure without db set
SQL
0 vote138 views1 answer
Mysql custom sort order
SQL