SQL ServerSecurity & users

Members of the sysadmin role

Every login with full control of the instance. Worth reviewing on a schedule and after any access request.

Not yet verified. How scripts are tested

b-mssql-sysadmin.sql

1SELECT p.name AS login_name, p.type_desc, p.is_disabled, p.create_date2FROM sys.server_role_members rm3JOIN sys.server_principals r ON r.principal_id = rm.role_principal_id4JOIN sys.server_principals p ON p.principal_id = rm.member_principal_id5WHERE r.name = 'sysadmin'6ORDER BY p.name;

Paste it into your query tool.

Open in denrepo