title: Google Cloud SQL Database Modified or Deleted
id: f346bbd5-2c4e-4789-a221-72de7685090d
description: Detect when a Cloud SQL DB has been modified or deleted.
author: Austin Songer @austinsonger
status: experimental
date: 2021/10/15
references:
    - https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/users/update
logsource:
  product: gcp
  service: gcp.audit
detection:
    selection:
        gcp.audit.method_name: 
            - cloudsql.instances.create
            - cloudsql.instances.delete
            - cloudsql.users.update
            - cloudsql.users.delete
    condition: selection
level: medium
tags:
    - attack.impact
falsepositives:
 - 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.
