forked from vincent/notebook
19 lines
574 B
SQL
19 lines
574 B
SQL
SELECT *
|
|
FROM sys.server_principals;
|
|
|
|
SELECT *
|
|
FROM sys.server_role_members;
|
|
|
|
SELECT usr.name AS UTILISATEUR, 'MEMBRE DU ROLE', rol.name AS ROLE
|
|
FROM sys.server_role_members AS srm
|
|
JOIN sys.server_principals AS usr
|
|
ON srm.member_principal_id = usr.principal_id
|
|
JOIN sys.server_principals AS rol
|
|
ON srm.role_principal_id = rol.principal_id;
|
|
|
|
SELECT p.*, ep.name
|
|
FROM sys.server_permissions AS p
|
|
LEFT OUTER JOIN sys.endpoints AS ep
|
|
ON p.major_id = ep.endpoint_id AND p.class_desc = 'ENDPOINT'
|
|
|