Detectionmediumtest
Google Cloud SQL Database Modified or Deleted
Detect when a Cloud SQL DB has been modified or deleted.
Convert In Phoenix Studio
Open this Sigma rule in the converter with the YAML preloaded and ready for backend selection.
Launch
Log Source
Google Cloudgcp.audit
ProductGoogle Cloud← raw: gcp
Servicegcp.audit← raw: gcp.audit
Detection Logic
Detection Logic1 selector
detection:
selection:
gcp.audit.method_name:
- cloudsql.instances.create
- cloudsql.instances.delete
- cloudsql.users.update
- cloudsql.users.delete
condition: selectionFalse Positives
SQL Database being modified or deleted may be performed by a system administrator.
Verify whether the user identity, user agent, and/or hostname should be making changes in your environment.
SQL Database modified or deleted from unfamiliar users should be investigated. If known behavior is causing false positives, it can be exempted from the rule.
References
MITRE ATT&CK
Tactics
Rule Metadata
Rule ID
f346bbd5-2c4e-4789-a221-72de7685090d
Status
test
Level
medium
Type
Detection
Created
Fri Oct 15
Modified
Sun Dec 25
Author
Path
rules/cloud/gcp/audit/gcp_sql_database_modified_or_deleted.yml
Raw Tags
attack.impact