Check user roles
Tue Nov 21 2023 15:38:27 GMT+0000 (Coordinated Universal Time)
Saved by
@merol007
SELECT
roles.principal_id AS RolePrincipalID
,roles.name AS RolePrincipalName
,database_role_members.member_principal_id AS MemberPrincipalID
,members.name AS MemberPrincipalName
FROM sys.database_role_members AS database_role_members
JOIN sys.database_principals AS roles
ON database_role_members.role_principal_id = roles.principal_id
JOIN sys.database_principals AS members
ON database_role_members.member_principal_id = members.principal_id
content_copyCOPY
Comments