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 votes285 views2 answers
MySQL DISTINCT
SQL
0 vote282 views4 answers
Sql year
SQL
31 votes310 views4 answers
Mysql grant execute
SQL
1 vote296 views1 answer
Oracle grant on all tables in schema
SQL
0 vote343 views3 answers
Characters found after end of sql statement
SQL
5 votes294 views1 answer
Oracle nls parameters
SQL
0 vote302 views1 answer
Sintaxis SELECT sql
SQL
0 vote300 views1 answer
Sql server create constraint
SQL
0 vote303 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote306 views1 answer
Authentication in sql server
SQL