Lookup Tables

The following lookup tables map internal audit codes to keywords that are basically understandable to humans. The first three tables are created as part of the database creation process from the sql.bsq file; AUDIT_ACTIONS is created by the cataudit.sql script.

TABLE_PRIVILEGE_MAP

Lists the valid object audit options that can be specified for schema object auditing

SYSTEM_PRIVILEGE_MAP

Lists the valid system privileges that can be specified for system privilege auditing

STMT_AUDIT_OPTION_MAP

Lists the valid SQL statements that can be specified for statement auditing

AUDIT_ACTIONS

Lists the internal audit codes and descriptions

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.