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 AI Database where unified auditing is enabled.

    • See Oracle AI Database Security Guide for more information about unified auditing.

    • See Oracle AI Database Upgrade Guide for more information about migrating to unified auditing.

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”