MSSQL Destructive Query
Last updated on:
In this page
About the rule
Rule Type
Standard
Rule Description
Detects the invocation of MS SQL queries that destruct the table or database , such as "DROP TABLE" or "DROP DATABASE".
Severity
Trouble
Rule Requirement
Criteria
Action1: actionname = "sa_sql_operation" AND (STATEMENT contains "TRUNCATE TABLE" OR STATEMENT contains "DROP TABLE" OR STATEMENT contains "DROP DATABASE") 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
