Cloud SQL for MySQL audit logging

This document describes audit logging for Cloud SQL. Google Cloud services generate audit logs that record administrative and access activities within your Google Cloud resources. For more information about Cloud Audit Logs, see the following:

Service name

Cloud SQL audit logs use the service name cloudsql.googleapis.com. Filter for this service: 

    protoPayload.serviceName="cloudsql.googleapis.com"

Methods by permission type

Each IAM permission has a type property, whose value is an enum that can be one of four values: ADMIN_READ, ADMIN_WRITE, DATA_READ, or DATA_WRITE. When you call a method, Cloud SQL generates an audit log whose category is dependent on the type property of the permission required to perform the method. Methods that require an IAM permission with the type property value of DATA_READ, DATA_WRITE, or ADMIN_READ generate Data Access audit logs. Methods that require an IAM permission with the type property value of ADMIN_WRITE generate Admin Activity audit logs.

Permission type Methods
ADMIN_READ cloudsql.backupRuns.get
cloudsql.backupRuns.list
cloudsql.backups.list
cloudsql.instances.get
cloudsql.instances.list
cloudsql.instances.listServerCas
cloudsql.operations.get
cloudsql.operations.list
cloudsql.sslCerts.get
cloudsql.sslCerts.list
ADMIN_WRITE cloudsql.backupRuns.create
cloudsql.backupRuns.delete
cloudsql.backups.create
cloudsql.backups.delete
cloudsql.backups.update
cloudsql.instances.addServerCa
cloudsql.instances.clone
cloudsql.instances.connect
cloudsql.instances.create
cloudsql.instances.delete
cloudsql.instances.demoteMaster
cloudsql.instances.failover
cloudsql.instances.migrate
cloudsql.instances.promoteReplica
cloudsql.instances.reencrypt
cloudsql.instances.resetSslConfig
cloudsql.instances.restart
cloudsql.instances.restoreBackup
cloudsql.instances.rotateServerCa
cloudsql.instances.startReplica
cloudsql.instances.stopReplica
cloudsql.instances.truncateLog
cloudsql.instances.update
cloudsql.sslCerts.create
cloudsql.sslCerts.delete
DATA_READ cloudsql.databases.get
cloudsql.databases.list
cloudsql.instances.export
cloudsql.users.get
cloudsql.users.list
DATA_WRITE cloudsql.databases.create
cloudsql.databases.delete
cloudsql.databases.update
cloudsql.instances.executeSql
cloudsql.instances.import
cloudsql.instances.login
cloudsql.users.create
cloudsql.users.delete
cloudsql.users.update

API interface audit logs

For information about how and which permissions are evaluated for each method, see the Identity and Access Management documentation for Cloud SQL.

cloudsql.backupRuns

The following audit logs are associated with methods belonging to cloudsql.backupRuns.

create

  • Method: cloudsql.backupRuns.create
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.backupRuns.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.backupRuns.create"

delete

  • Method: cloudsql.backupRuns.delete
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.backupRuns.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.backupRuns.delete"

get

  • Method: cloudsql.backupRuns.get
  • Audit log type: Data access
  • Permissions:
    • cloudsql.backupRuns.get - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.backupRuns.get"

list

  • Method: cloudsql.backupRuns.list
  • Audit log type: Data access
  • Permissions:
    • cloudsql.backupRuns.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.backupRuns.list"

cloudsql.backups

The following audit logs are associated with methods belonging to cloudsql.backups.

create

  • Method: cloudsql.backups.create
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.backupRuns.create - ADMIN_WRITE
    • cloudsql.backups.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.backups.create"

delete

  • Method: cloudsql.backups.delete
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.backupRuns.delete - ADMIN_WRITE
    • cloudsql.backups.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.backups.delete"

list

  • Method: cloudsql.backups.list
  • Audit log type: Data access
  • Permissions:
    • cloudsql.backupRuns.list - ADMIN_READ
    • cloudsql.backups.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.backups.list"

update

  • Method: cloudsql.backups.update
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.backupRuns.update - ADMIN_WRITE
    • cloudsql.backups.update - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.backups.update"

cloudsql.databases

The following audit logs are associated with methods belonging to cloudsql.databases.

create

  • Method: cloudsql.databases.create
  • Audit log type: Data access
  • Permissions:
    • cloudsql.databases.create - DATA_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.databases.create"

delete

  • Method: cloudsql.databases.delete
  • Audit log type: Data access
  • Permissions:
    • cloudsql.databases.delete - DATA_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.databases.delete"

get

  • Method: cloudsql.databases.get
  • Audit log type: Data access
  • Permissions:
    • cloudsql.databases.get - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.databases.get"

list

  • Method: cloudsql.databases.list
  • Audit log type: Data access
  • Permissions:
    • cloudsql.databases.list - DATA_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.databases.list"

update

  • Method: cloudsql.databases.update
  • Audit log type: Data access
  • Permissions:
    • cloudsql.databases.update - DATA_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.databases.update"

cloudsql.instances

The following audit logs are associated with methods belonging to cloudsql.instances.

addServerCa

  • Method: cloudsql.instances.addServerCa
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.addServerCa - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.addServerCa"

clone

  • Method: cloudsql.instances.clone
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.clone - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.clone"

connect

  • Method: cloudsql.instances.connect
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.connect - ADMIN_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.connect"

create

  • Method: cloudsql.instances.create
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.create"

delete

  • Method: cloudsql.instances.delete
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.delete"

demoteMaster

  • Method: cloudsql.instances.demoteMaster
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.demoteMaster - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.demoteMaster"

executeSql

  • Method: cloudsql.instances.executeSql
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.executeSql - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.executeSql"

export

  • Method: cloudsql.instances.export
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.export - DATA_READ
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.export"

failover

  • Method: cloudsql.instances.failover
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.failover - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.failover"

get

  • Method: cloudsql.instances.get
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.get - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.get"

import

  • Method: cloudsql.instances.import
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.import - DATA_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.import"

list

  • Method: cloudsql.instances.list
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.list"

listServerCas

  • Method: cloudsql.instances.listServerCas
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.listServerCas - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.listServerCas"

login

  • Method: cloudsql.instances.login
  • Audit log type: Data access
  • Permissions:
    • cloudsql.instances.login - DATA_WRITE
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="cloudsql.instances.login"

migrate

  • Method: cloudsql.instances.migrate
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.migrate - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.migrate"

promoteReplica

  • Method: cloudsql.instances.promoteReplica
  • Audit log type: Admin activity
  • Permissions:
    • cloudsql.instances.promoteReplica - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="cloudsql.instances.promoteReplica"

query

  • Method: cloudsql.instances.query
  • Audit log type: Data access
  • Permissions:
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.instances.query"

    reencrypt

    • Method: cloudsql.instances.reencrypt
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.reencrypt - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.reencrypt"

    resetSslConfig

    • Method: cloudsql.instances.resetSslConfig
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.resetSslConfig - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.resetSslConfig"

    restart

    • Method: cloudsql.instances.restart
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.restart - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.restart"

    restoreBackup

    • Method: cloudsql.instances.restoreBackup
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.restoreBackup - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.restoreBackup"

    rotateServerCa

    • Method: cloudsql.instances.rotateServerCa
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.rotateServerCa - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.rotateServerCa"

    startReplica

    • Method: cloudsql.instances.startReplica
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.startReplica - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.startReplica"

    stopReplica

    • Method: cloudsql.instances.stopReplica
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.stopReplica - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.stopReplica"

    truncateLog

    • Method: cloudsql.instances.truncateLog
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.truncateLog - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.truncateLog"

    update

    • Method: cloudsql.instances.update
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.instances.update - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.instances.update"

    cloudsql.operations

    The following audit logs are associated with methods belonging to cloudsql.operations.

    get

    • Method: cloudsql.operations.get
    • Audit log type: Data access
    • Permissions:
      • cloudsql.instances.get - ADMIN_READ
      • cloudsql.operations.get - ADMIN_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.operations.get"

    list

    • Method: cloudsql.operations.list
    • Audit log type: Data access
    • Permissions:
      • cloudsql.instances.get - ADMIN_READ
      • cloudsql.operations.list - ADMIN_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.operations.list"

    cloudsql.sslCerts

    The following audit logs are associated with methods belonging to cloudsql.sslCerts.

    create

    • Method: cloudsql.sslCerts.create
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.sslCerts.create - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.sslCerts.create"

    delete

    • Method: cloudsql.sslCerts.delete
    • Audit log type: Admin activity
    • Permissions:
      • cloudsql.sslCerts.delete - ADMIN_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.sslCerts.delete"

    get

    • Method: cloudsql.sslCerts.get
    • Audit log type: Data access
    • Permissions:
      • cloudsql.sslCerts.get - ADMIN_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.sslCerts.get"

    list

    • Method: cloudsql.sslCerts.list
    • Audit log type: Data access
    • Permissions:
      • cloudsql.sslCerts.list - ADMIN_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.sslCerts.list"

    cloudsql.users

    The following audit logs are associated with methods belonging to cloudsql.users.

    create

    • Method: cloudsql.users.create
    • Audit log type: Data access
    • Permissions:
      • cloudsql.users.create - DATA_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.users.create"

    delete

    • Method: cloudsql.users.delete
    • Audit log type: Data access
    • Permissions:
      • cloudsql.users.delete - DATA_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.users.delete"

    get

    • Method: cloudsql.users.get
    • Audit log type: Data access
    • Permissions:
      • cloudsql.users.get - DATA_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.users.get"

    list

    • Method: cloudsql.users.list
    • Audit log type: Data access
    • Permissions:
      • cloudsql.users.list - DATA_READ
    • Method is a long-running or streaming operation: No.
    • Filter for this method: protoPayload.methodName="cloudsql.users.list"

    update

    • Method: cloudsql.users.update
    • Audit log type: Data access
    • Permissions:
      • cloudsql.users.update - DATA_WRITE
    • Method is a long-running or streaming operation: Long-running operation
    • Filter for this method: protoPayload.methodName="cloudsql.users.update"

    System events

    System Event audit logs are generated by GCP systems, not direct user action. For more information, see System Event audit logs.

    Method Name Filter For This Event Notes
    cloudsql.instances.autoFailover protoPayload.methodName="cloudsql.instances.autoFailover"
    cloudsql.instances.automatedBackup protoPayload.methodName="cloudsql.instances.automatedBackup"
    cloudsql.instances.automaticStorageIncrease protoPayload.methodName="cloudsql.instances.automaticStorageIncrease"