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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX_ACTIVITY_LOG and APEX_WORKSPACE_ACTIVITY_LOG Information

Sandipan2 days ago

Hi Team,

We are trying to build an application with restricted data (PII) and have extensive DB and Application logging requirements as part of security clearance.

For DB we are using Autonomous Database Serverless and we have OCI native features like, Database Management, Data Safe etc enabled to audit trail DB Activities.

For APEX Application logging I believe, APEX_ACTIVITY_LOG and APEX_WORKSPACE_ACTIVITY_LOG records every activity by end users or developers.

We have few questions:

Can anybody with high privilege delete any records from activity log tables?
Is there any way to move APEX activity logs to OCI Data Safe or any other central place where these logs can be monitored outside the APEX environment?

Thanks

Sandipan

jariola

Can anybody with high privilege delete any records from activity log tables?

By default APEX rotates those logs and keeps only 14 days. So you need store history by yourself somewhere. I'm not sure can you transfer those to Data Safe. But most probably you can transfer those to logging service.

Sandipan

What is this logging service?

jariola