Users associated with database roles.

Below code lists all the database users that are associated with all the roles present in the database.

select B.Name as [Database Role],C.Name as [Database UserName]
from sys.database_role_members A
INNER JOIN sys.database_principals B on B.principal_id=A.role_principal_id
INNER JOIN sys.database_principals C on A.member_principal_id=C.principal_id

Advertisement