MSSQL Disable Audit Settings
Last updated on:
In this page
About the rule
Rule Type
Standard
Rule Description
Detects instances where an attacker calls the "ALTER SERVER AUDIT" or "DROP SERVER AUDIT" query in order to delete or disable audit logs on the server.
Severity
Trouble
Rule Requirement
Criteria
Action1: actionname = "sa_sql_operation" AND (STATEMENT contains "ALTER SERVER AUDIT" OR STATEMENT contains "DROP SERVER AUDIT") select Action1.USERNAME,Action1.MESSAGE,Action1.DOMAIN,Action1.HOSTNAME,Action1.STATEMENT,Action1.OBJECTNAME,Action1.SCHEMANAME,Action1.DATABASENAME,Action1.INSTANCENAME
Detection
Execution Mode
Realtime
Log Sources
SQL Server
Author
Nasreddine Bencherchali (Nextron Systems)
