Oracle Database@Google Cloud audit logging

This document describes audit logging for Oracle Database@Google Cloud. 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

Oracle Database@Google Cloud audit logs use the service name oracledatabase.googleapis.com. Filter for this service: 

    protoPayload.serviceName="oracledatabase.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, Oracle Database@Google Cloud 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 google.cloud.oracledatabase.v1.OracleDatabase.GenerateAutonomousDatabaseWallet
google.cloud.oracledatabase.v1.OracleDatabase.GetAutonomousDatabase
google.cloud.oracledatabase.v1.OracleDatabase.GetCloudExadataInfrastructure
google.cloud.oracledatabase.v1.OracleDatabase.GetCloudVmCluster
google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseBackups
google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseCharacterSets
google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabases
google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDbVersions
google.cloud.oracledatabase.v1.OracleDatabase.ListCloudExadataInfrastructures
google.cloud.oracledatabase.v1.OracleDatabase.ListCloudVmClusters
google.cloud.oracledatabase.v1.OracleDatabase.ListDbNodes
google.cloud.oracledatabase.v1.OracleDatabase.ListDbServers
google.cloud.oracledatabase.v1.OracleDatabase.ListDbSystemShapes
google.cloud.oracledatabase.v1.OracleDatabase.ListEntitlements
google.cloud.oracledatabase.v1.OracleDatabase.ListGiVersions
ADMIN_WRITE google.cloud.oracledatabase.v1.OracleDatabase.CreateAutonomousDatabase
google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudExadataInfrastructure
google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudVmCluster
google.cloud.oracledatabase.v1.OracleDatabase.DeleteAutonomousDatabase
google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudExadataInfrastructure
google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudVmCluster
google.cloud.oracledatabase.v1.OracleDatabase.RestoreAutonomousDatabase

API interface audit logs

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

google.cloud.oracledatabase.v1.OracleDatabase

The following audit logs are associated with methods belonging to google.cloud.oracledatabase.v1.OracleDatabase.

CreateAutonomousDatabase

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.CreateAutonomousDatabase
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.autonomousDatabases.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.CreateAutonomousDatabase"

CreateCloudExadataInfrastructure

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudExadataInfrastructure
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.cloudExadataInfrastructures.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudExadataInfrastructure"

CreateCloudVmCluster

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudVmCluster
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.cloudExadataInfrastructures.use - ADMIN_READ
    • oracledatabase.cloudVmClusters.create - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.CreateCloudVmCluster"

DeleteAutonomousDatabase

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.DeleteAutonomousDatabase
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.autonomousDatabases.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.DeleteAutonomousDatabase"

DeleteCloudExadataInfrastructure

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudExadataInfrastructure
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.cloudExadataInfrastructures.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudExadataInfrastructure"

DeleteCloudVmCluster

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudVmCluster
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.cloudVmClusters.delete - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.DeleteCloudVmCluster"

GenerateAutonomousDatabaseWallet

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.GenerateAutonomousDatabaseWallet
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDatabases.generateWallet - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.GenerateAutonomousDatabaseWallet"

GetAutonomousDatabase

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.GetAutonomousDatabase
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDatabases.get - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.GetAutonomousDatabase"

GetCloudExadataInfrastructure

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.GetCloudExadataInfrastructure
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.cloudExadataInfrastructures.get - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.GetCloudExadataInfrastructure"

GetCloudVmCluster

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.GetCloudVmCluster
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.cloudVmClusters.get - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.GetCloudVmCluster"

ListAutonomousDatabaseBackups

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseBackups
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDatabaseBackups.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseBackups"

ListAutonomousDatabaseCharacterSets

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseCharacterSets
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDatabaseCharacterSets.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabaseCharacterSets"

ListAutonomousDatabases

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabases
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDatabases.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDatabases"

ListAutonomousDbVersions

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDbVersions
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.autonomousDbVersions.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListAutonomousDbVersions"

ListCloudExadataInfrastructures

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListCloudExadataInfrastructures
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.cloudExadataInfrastructures.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListCloudExadataInfrastructures"

ListCloudVmClusters

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListCloudVmClusters
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.cloudVmClusters.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListCloudVmClusters"

ListDbNodes

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListDbNodes
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.dbNodes.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListDbNodes"

ListDbServers

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListDbServers
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.dbServers.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListDbServers"

ListDbSystemShapes

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListDbSystemShapes
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.dbSystemShapes.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListDbSystemShapes"

ListEntitlements

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListEntitlements
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.entitlements.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListEntitlements"

ListGiVersions

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.ListGiVersions
  • Audit log type: Data access
  • Permissions:
    • oracledatabase.giVersions.list - ADMIN_READ
  • Method is a long-running or streaming operation: No.
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.ListGiVersions"

RestoreAutonomousDatabase

  • Method: google.cloud.oracledatabase.v1.OracleDatabase.RestoreAutonomousDatabase
  • Audit log type: Admin activity
  • Permissions:
    • oracledatabase.autonomousDatabases.restore - ADMIN_WRITE
  • Method is a long-running or streaming operation: Long-running operation
  • Filter for this method: protoPayload.methodName="google.cloud.oracledatabase.v1.OracleDatabase.RestoreAutonomousDatabase"

Methods that don't produce audit logs

A method might not produce audit logs for one or more of the following reasons:

  • It is a high volume method involving signifcant log generation and storage costs.
  • It has low auditing value.
  • Another audit or platform log already provides method coverage.

The following methods don't produce audit logs:

  • google.cloud.location.Locations.GetLocation
  • google.cloud.location.Locations.ListLocations
  • google.longrunning.Operations.CancelOperation
  • google.longrunning.Operations.DeleteOperation
  • google.longrunning.Operations.GetOperation
  • google.longrunning.Operations.ListOperations
  • google.longrunning.Operations.WaitOperation