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 SEPTEMBER 08, 2010

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.3 and later   [Release: 4.5 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?


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms