My Oracle Support Banner

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.

Goal

    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.

 

Solution

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
Goal
Solution


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