Get Privileged Logins
mssql_privileged_loginsAudit SQL Server sysadmin and securityadmin role members, marking accounts as Expected, Built-in, or REVIEW. Pass expectedAccounts to reduce false positives.
Instructions
Security: members of the sysadmin and securityadmin server roles, each marked Expected (in expectedAccounts), Built-in (sa, NT SERVICE*, NT AUTHORITY\SYSTEM, ##...##) or REVIEW. Needs VIEW ANY DEFINITION to see all members. Not available on Azure SQL Database.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| expectedAccounts | No | Logins expected to hold these roles (e.g. service or DBA accounts). Case-insensitive. They are marked Expected instead of REVIEW. |