My Oracle Support Banner

How to Deal with Updates to the User Column on OPA_LEVEL_PRIVS$JN Records When Generating Study Audit Report (Doc ID 1191283.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Information in this document applies to any platform.


On RDC Onsite Study/Site security, when updating the user access for study/site, the record will be inserted in the OPA_LEVEL_PRIVS$JN as an UPD and there will be no entry for the old user access being deleted. How can that situation be captured in an audit report to show the history of accesses granted to users for a particular study?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.