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

47 votes212 views6 answers
Add column mysql
SQL
0 vote201 views1 answer
Postgres create extension if not exists
SQL
0 vote188 views1 answer
How many columns can be used for creating index?
SQL
92 votes324 views6 answers
Substring
SQL
0 vote183 views1 answer
Opensuse start MySQL
SQL
0 vote220 views1 answer
Create synonym for dblink in oracle
SQL
0 vote196 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote190 views1 answer
Permission denied postgres \copy csv command line
SQL
2 votes197 views3 answers
Sql server reseed identity column
SQL
0 vote172 views1 answer
Mql5 list all available symbols
SQL