APEX

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!

Has anyone used database auditing with APEX?

John_KNov 24 2017 — edited Nov 24 2017

I'm looking at enabling database level audit on tables updated by an APEX app. The problem I have however is that the auditing o course shows the database user - which is always APEX_PUBLIC_USER.

I.e.

1 select audit_type, dbusername, event_timestamp, sql_text

2 from

3 unified_audit_trail

4* where unified_audit_policies='XXJKTST'

SQL> /

AUDIT_TYPE DBUSERNAME EVENT_TIME SQL_TEXT

-------------------- -------------------- ---------- ----------------------------------------------------------------------------------------------------

Standard APEX_PUBLIC_USER 24-NOV-17 update xxdemo set a=1 where a=2

09.48.11.7

92429 AM

Standard APEX_PUBLIC_USER 24-NOV-17 UPDATE XXDEMO SET A=1

09.49.21.3

55988 AM

2 rows selected.

SQL>

Has anyone done anything similar and managed to audit the APEX user within unified audit trail? https://docs.oracle.com/database/121/REFRN/GUID-B7CE1C02-2FD4-47D6-80AA-CF74A60CDD1D.htm#REFRN29162

Thanks

This post has been answered by fac586 on Nov 24 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2017

Added on Nov 24 2017

#apex-discussions

9 comments

1,489 views