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

23 votes100 views3 answers
Mysqldump
SQL
0 vote168 views1 answer
SQL-Arten
SQL
0 vote129 views1 answer
Default order by in mysql
SQL
0 vote129 views1 answer
Mariadb cast to int
SQL
3 votes132 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
31 votes129 views3 answers
Sql count(*)
SQL
8 votes163 views1 answer
Racle create auto increment column
SQL
10 votes153 views2 answers
Select nextval from sequence oracle
SQL
0 vote113 views1 answer
Count the table indatabase
SQL
4 votes136 views2 answers
Sqlalchemy_database_uri for mysql
SQL