detection.wiki

Detection rules › Sigma

Google Cloud SQL Database Modified or Deleted

Status
test
Severity
medium
Log source
product gcp, service gcp.audit
Author
Austin Songer @austinsonger
Source
github.com/SigmaHQ/sigma

Detect when a Cloud SQL DB has been modified or deleted.

Known false 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.

MITRE ATT&CK coverage

TacticTechniques
ImpactNo specific technique

Telemetry coverage

PlatformRecord / event type
GCPcloudsql.instances.create: Create instance
GCPcloudsql.instances.delete: Delete instance
GCPcloudsql.users.delete: Delete database user
GCPcloudsql.users.update: Update database user

Rule body

title: Google Cloud SQL Database Modified or Deleted
id: f346bbd5-2c4e-4789-a221-72de7685090d
status: test
description: Detect when a Cloud SQL DB has been modified or deleted.
references:
    - https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/users/update
author: Austin Songer @austinsonger
date: 2021-10-15
modified: 2022-12-25
tags:
    - attack.impact
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
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.
level: medium

Stages and Predicates

Stage 0: condition

selection

Stage 1: selection

selection:
    gcp.audit.method_name:
        - cloudsql.instances.create
        - cloudsql.instances.delete
        - cloudsql.users.update
        - cloudsql.users.delete

Indicators

These rows show field, operator, and value matches.

FieldKindValuesSearch
gcp.audit.method_nameeq
  • cloudsql.instances.create
  • cloudsql.instances.delete
  • cloudsql.users.delete
  • cloudsql.users.update
field:"gcp::method_name" kind:eq