Detection: SQL User Deleted

Overview

Detect when an SQL user was deleted. User deletions may result in the loss of critical access permissions or indicate unauthorized privilege modifications. Monitoring these actions helps maintain secure database access controls and detect potential account tampering.

References:

Usage

Run the detection in your terminal:

powerpipe detection run gcp_audit_log_detections.detection.sql_user_deleted

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run gcp_audit_log_detections.detection.sql_user_deleted --share

SQL

This detection uses a named query:

select
  tp_timestamp as timestamp,
method_name as operation,
resource_name as resource,
authentication_info.principal_email as actor,
tp_source_ip as source_ip,
tp_index as project,
tp_id as source_id,
-- Create new aliases to preserve original row data
*

from
  gcp_audit_log
where
  method_name ilike 'cloudsql.users.delete'
  and severity != 'Error'
-- TODO: Do we need to check operation?
-- and (operation_src is null or operation_src.last = true)

order by
  timestamp desc;

Detection: SQL User Deleted

Overview

Usage

SQL

Tags