3.176 AUDITABLE_SYSTEM_ACTIONS

AUDITABLE_SYSTEM_ACTIONS maps the auditable system action numbers to the action names. These actions are configurable for audit when unified auditing is enabled.

The actions include:

  • All standard RDBMS actions (from the V$SQLCOMMAND view) except the following, which are not configurable for auditing:

    • ALTER EDITION

    • ALTER REWRITE EQUIVALENCE

    • ALTER SUMMARY

    • ALTER TRACING

    • CREATE BITMAPFILE

    • CREATE CONTROL FILE

    • CREATE DATABASE

    • CREATE SUMMARY

    • DECLARE REWRITE EQUIVALENCE

    • DROP BITMAPFILE

    • DROP DATABASE

    • DROP REWRITE EQUIVALENCE

    • DROP SUMMARY

    • FLASHBACK DATABASE

    • MERGE

    • SAVEPOINT

    • SET CONSTRAINTS

    • UNDROP OBJECT

    • UPDATE INDEXES

    • UPDATE JOIN INDEX

    • VALIDATE INDEX

  • Other actions:

    • ALL

    • LOGON

    • LOGOFF

Note:

This view is populated only in an Oracle Database where unified auditing is enabled.

Column Datatype NULL Description

TYPE

NUMBER

Numeric component type for system wide actions

COMPONENT

VARCHAR2(64)

Name of component for system wide actions

ACTION

NUMBER

Numeric auditable action code for system wide actions

NAME

VARCHAR2(64)

Name of auditable action

Some auditable actions in AUDITABLE_SYSTEM_ACTIONS have different names than their equivalent commands in V$SQLCOMMAND, as shown in the following table:

AUDITABLE_SYSTEM_ACTIONS Action Name V$SQLCOMMAND Command Name

GRANT

GRANT OBJECT

REVOKE

REVOKE OBJECT

AUDIT

AUDIT OBJECT

NOAUDIT

NOAUDIT OBJECT

EXECUTE

PL/SQL EXECUTE

EXPLAIN PLAN

EXPLAIN

CALL

CALL METHOD

PURGE DBA_RECYCLEBIN

PURGE DBA RECYCLEBIN

See Also:

"V$SQLCOMMAND"