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

2 votes278 views1 answer
Sql find not in list
SQL
0 vote246 views1 answer
Remove default constraint sql server
SQL
0 vote238 views1 answer
Check if a word appears at the end sql query
SQL
0 vote262 views4 answers
Mysql on kubernetes
SQL
0 vote265 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote250 views1 answer
Oracle synonym procedure
SQL
0 vote260 views1 answer
Character count sql
SQL
4 votes248 views1 answer
Mysql biginteger size
SQL
0 vote259 views1 answer
Copy value from one column to another postgres
SQL
0 vote262 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL