USER_AUDIT_OBJECT

Purpose

The USER_AUDIT_OBJECT view displays the audit trail records of objects accessible to the current user.

Columns

Sample query

Query the audit trail entries of all objects under the current user.

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

The query result is as follows:

+----------+----------------+-----------+-------------+------------------------------------+
| USERNAME | USERHOST       | TIMESTAMP | ACTION_NAME | SQL_TEXT                           |
+----------+----------------+-----------+-------------+------------------------------------+
| TEST2    | 100.xx.xxx.xxx | 08-APR-25 | SELECT      | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
| TEST2    | 100.xx.xxx.xxx | 08-APR-25 | SELECT      | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
| TEST2    | 100.xx.xxx.xxx | 08-APR-25 | SELECT      | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
+----------+----------------+-----------+-------------+------------------------------------+
3 rows in set

References

• Query the audit trail entries of all objects under the current tenant: DBA_AUDIT_OBJECT

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

• Query the audit trail entries for CONNECT and DISCONNECT:

  • DBA_AUDIT_SESSION

  • USER_AUDIT_SESSION

• Query all audit trail entries:

  • DBA_AUDIT_TRAIL

  • USER_AUDIT_TRAIL

• Query 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