3.175 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$SQLCOMMANDview) 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
-
Do not use 184
-
Do not use 185
-
Do not use 186
-
DECLARE REWRITE EQUIVALENCE
-
DROP BITMAPFILE
-
DROP DATABASE
-
DROP REWRITE EQUIVALENCE
-
DROP SUMMARY
-
FLASHBACK DATABASE
-
MERGE
-
NO-OP (No operation)
-
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.
-
See Oracle Database Security Guide for more information about unified auditing.
-
See Oracle Database Upgrade Guide for more information about migrating to unified auditing.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Numeric component type for system wide actions |
|
|
|
|
Name of component for system wide actions |
|
|
|
|
Numeric auditable action code for system wide actions |
|
|
|
|
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: