DISCREPANCIES_V Hits ORA-01031: "insufficient privileges" Via Custom Program
(Doc ID 2763400.1)
Last updated on APRIL 06, 2021
Applies to:Oracle Life Sciences Data Hub - Version 2.5.0 and later
Oracle Health Sciences Data Management Workbench - Version 2.5.0 and later
Information in this document applies to any platform.
To avoid the error "ORA-01031: insufficient privileges" when accessing the DISCREPANCIES_V view from custom program.
The error was encountered by customer by executing the following steps:
1. The customer has created a custom program that accessed the DISCREPANCIES_V view.
2. The custom code included the "AUTHID CURRENT_USER" instruction:
3. The program was launched from LSH/DMW UI.
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