SQL Server - Permissions

permissions.sql

-- privileges
select [Grantee] = prin.name
     , [Grantee Type] = prin.type_desc
     , [Permission] = perm.permission_name
     , [State] = perm.state_desc
     , [Class] = perm.class_desc
     , [Object] = object_name(perm.major_id)
  from sys.database_principals prin
  left join sys.database_permissions perm on perm.grantee_principal_id = prin.principal_id
 
-- roles
select roles.name as role_name
     , members.name as member_name
     , members.type_desc as member_type
  from sys.database_principals roles
  left join sys.database_role_members x on x.role_principal_id = roles.principal_id
  left join sys.database_principals members on members.principal_id = x.member_principal_id
 where roles.type = 'R'