AUDIT_ACTIONS

Purpose

This view records the action IDs and their corresponding names in audit records.

Columns

Sample query

Query the first 10 action IDs and their corresponding names in the audit 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 the AUDIT EXISTS and AUDIT NOT EXISTS statements: 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 the 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