Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19c SE2, DBA_AUDIT_TRAIL

user545194Nov 13 2025 — edited Nov 13 2025

Env. 19c SE2

We have to use the conventional audit trail method. Implemented according to the docs, but no entries in the dba_audit_trail.

Steps done:

  1. Created a new tablespace
  2. Set new tablespace via the dbms_audit_mgmt package
  3. Initialized Audit Trail
  4. Checked the audit mgmt configuration parameters → ok
  5. Checked if “Unified Auditing” is being used → FALSE
  6. Parameter AUDIT_TRAIL = db
  7. Activated AUDIT for CREATE TABLE BY ACCESS
  8. Created a table
  9. Queried dba_audit_trail, but no entries

All steps performed by a privileged user (not SYS). Did we miss something here?

Thanks!

This post has been answered by Gerrit van der Linden on Nov 13 2025
Jump to Answer
Comments
Post Details
Added on Nov 13 2025
6 comments
128 views