Drop attempts stateful anomaly on database

This query detects batches of distinct SQL queries that execute (or attempt to) commands that could indicate potential security issues - such as attempts to drop tables or databases (e.g. for data vandalism).

Detection logic

Detection requirements

Platform: Containers ESXi IaaS Linux macOS Windows
The rule states no platform. This is derived from the ATT&CK technique it maps to.
Log source product: azuresql
Log source service: azurediagnostics

Detections can measure how the public catalogue is used — which detections people look for, and which pages bring them here. It sets a cookie that recognises this browser for 180 days. It is never linked to an account and never follows you to other sites. Privacy notice

Detection rules

Drop attempts stateful anomaly on database

Detection logic

Detection requirements

MITRE ATT&CK mappings

From the source

Licence

Authorship

Detection rules