Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/sqlserver/audit-logging below:

Cloud SQL for SQL Server audit logging

Stay organized with collections Save and categorize content based on your preferences.

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:

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

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

    protoPayload.serviceName="cloudsql.googleapis.com"
  

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.

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

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

• 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"
  

• 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"
  

• 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"
  

• 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"
  

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

• 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"
  

• 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"
  

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

• 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"
  

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

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

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

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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"
  

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

• 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"
  

• 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"
  

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

• 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"
  

• 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"
  

• 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"
  

• 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"
  

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

• 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"
  

• 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"
  

• 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"
  

• 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"
  

• 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 Event audit logs are generated by GCP systems, not direct user action. For more information, see System Event audit logs.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-02 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4