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

    • CREATE BITMAPFILE

    • CREATE CONTROL FILE

    • CREATE DATABASE

    • DECLARE REWRITE EQUIVALENCE

    • DROP BITMAPFILE

    • DROP DATABASE

    • DROP REWRITE EQUIVALENCE

    • FLASHBACK DATABASE

    • NO-OP (No operation)

  • 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


See Also:

"V$SQLCOMMAND"