DBA_STMT_AUDIT_OPTS

2025-11-19 10:08:13  Updated

Purpose

The DBA_STMT_AUDIT_OPTS view displays audit configuration details at the statement level.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

STMT_AUDIT_OPTION_MAP

Columns

Column Type Nullable? Description
USER_NAME VARCHAR2(128) NO The username of the user whose actions were audited.
PROXY_NAME VARCHAR2(128) NO The name of the proxy user whose actions were audited. The value is always NULL.
AUDIT_OPTION VARCHAR2(128) NO The type ID of auditing at the statement level.
SUCCESS VARCHAR2(10) NO The auditing mode when the statement is executed.
FAILURE VARCHAR2(10) NO The auditing mode when the statement failed to be executed.

Contact Us