B.19 Content of SQL_AUDITS

SQL_AUDITS stores audit target definition information defined by the CREATE AUDIT statement. Each row stores information for one audit target definition.

The following table describes the content of SQL_AUDITS:

Table B‒21: Content of SQL_AUDITS
No.	Column name	Data type	Stored information
1	`OPERATION_TYPE`	`VARCHAR(30)`	Target operation type `'ANY'`: All audit target operations
2	`EVENT_TYPE`	`VARCHAR(30)`	Used by the system
3	`OBJECT_TYPE`	`VARCHAR(30)`	Used by the system
4	`OBJECT_SCHEMA`	`VARCHAR(100)`	Used by the system
5	`OBJECT_NAME`	`VARCHAR(100)`	Used by the system
6	`USER_NAME`	`VARCHAR(100)`	Used by the system
7	`EVENT_RESULT`	`VARCHAR(30)`	Used by the system
8	`AUDIT_TYPE`	`VARCHAR(30)`	Audit trail type `'EVENT'`: Final event result
9	`IS_EXCLUSION_AUDIT`	`CHAR(1)`	Used by the system

To Page Top