AUDIT_ACTIONS

Purpose

Records the action ID and the corresponding name in the audit records.

Columns

Sample query

Query the action ID and the corresponding name in the audit records, and display the first 10 records.

obclient [SYS]> SELECT * FROM SYS.AUDIT_ACTIONS WHERE ROWNUM <=10;

The query result is as follows:

+--------+----------------+
| ACTION | NAME           |
+--------+----------------+
|      0 | UNKNOWN        |
|      1 | CREATE TABLE   |
|      2 | INSERT         |
|      3 | SELECT         |
|      4 | CREATE CLUSTER |
|      5 | ALTER CLUSTER  |
|      6 | UPDATE         |
|      7 | DELETE         |
|      8 | DROP CLUSTER   |
|      9 | CREATE INDEX   |
+--------+----------------+
10 rows in set

References

• View the audit trail entries generated by AUDIT EXISTS and AUDIT NOT EXISTS: DBA_AUDIT_EXISTS

• View the audit trail entries for all objects:

  • DBA_AUDIT_OBJECT

  • USER_AUDIT_OBJECT

• View the audit trail entries for CONNECT and DISCONNECT:

  • DBA_AUDIT_SESSION

  • USER_AUDIT_SESSION

• View all audit trail entries:

  • DBA_AUDIT_TRAIL

  • USER_AUDIT_TRAIL

• View the audit trail entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements:

  • DBA_AUDIT_STATEMENT

  • USER_AUDIT_STATEMENT

• For more information about security audit, see the following topics:

  • Enable audit
  • Set up and view audit rules
  • View audit records
  • Audit user logon
  • Audit user operations