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

• Types of audit logs
• Audit log entry structure
• Storing and routing audit logs
• Cloud Logging pricing summary
• Enable Data Access audit logs

Service name

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

protoPayload.serviceName="cloudsql.googleapis.com"

Methods by permission type

Each IAM permission has atype property, whose value is an enumthat can be one of four values:ADMIN_READ,ADMIN_WRITE,DATA_READ, orDATA_WRITE. When you call a method,Cloud SQL generates an audit log whose category is dependent on thetype property of the permission required to perform the method.Methods that require an IAM permission with thetype property valueofDATA_READ,DATA_WRITE, orADMIN_READ generateData Access audit logs.Methods that require an IAM permission with thetype property valueofADMIN_WRITE generateAdmin Activity audit logs.

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 tocloudsql.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 tocloudsql.backups.

create

• Method:cloudsql.backups.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.backups.create"
  

delete

• Method:cloudsql.backups.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.backups.delete"
  

list

• Method:cloudsql.backups.list
  
• Audit log type:Data access
  
• Permissions:
  • cloudsql.backupRuns.list - ADMIN_READ
  • cloudsql.instances.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
• 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 tocloudsql.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 tocloudsql.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:Long-running operation
  
• 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 tocloudsql.operations.

get

• Method:cloudsql.operations.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.operations.get"
  

list

• Method:cloudsql.operations.list
  
• 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.operations.list"
  

cloudsql.sslCerts

The following audit logs are associated with methods belonging tocloudsql.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 tocloudsql.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, notdirect user action. For more information, seeSystem Event audit logs.