DBA_AUDIT_STATEMENT

Purpose

The DBA_AUDIT_STATEMENT view displays the audit trail records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the entire database.

Columns

Sample query

Query all audit trail entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the current tenant.

obclient [SYS]> SELECT USERNAME, USERHOST, TIMESTAMP, ACTION_NAME, SQL_TEXT FROM SYS.DBA_AUDIT_STATEMENT;

The query result is as follows:

+----------+----------------+-----------+--------------+---------------------------------+
| USERNAME | USERHOST       | TIMESTAMP | ACTION_NAME  | SQL_TEXT                        |
+----------+----------------+-----------+--------------+---------------------------------+
| SYS      | 100.xx.xxx.xxx | 08-APR-25 | ALTER SYSTEM | SET GLOBAL event_scheduler = ON |
+----------+----------------+-----------+--------------+---------------------------------+
1 row in set

References

• Query audit trail entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user: USER_AUDIT_STATEMENT

• Query audit trail entries for AUDIT EXISTS and AUDIT NOT EXISTS: DBA_AUDIT_EXISTS

• Query audit trail entries for all objects:

  • DBA_AUDIT_OBJECT

  • USER_AUDIT_OBJECT

• Query audit trail entries for CONNECT and DISCONNECT:

  • DBA_AUDIT_SESSION

  • USER_AUDIT_SESSION

• Query all audit trail entries:

  • DBA_AUDIT_TRAIL

  • USER_AUDIT_TRAIL

• 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