ORA-01031 Error Logging Into Discoverer Integrator As Non-Schema Owner

(Doc ID 312200.1)

Last updated on MARCH 20, 2013

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5

Checked for relevance on 20-Mar-2013.


While attempting to login to Discoverer Integrator using any end user account (the OFSA owner is the only account that works fine) the following errors result:

ORA-01031: insufficient privileges

select ofsa_tabs_columns_v.ofsa_data_type_cd, ofsa_tab_columns_v.display_name, ofsa_tabs_columns_v.description...
from ofsa_tab_columns_v where ofsa_tab_columns_v.table_name = 'OFSA_RESULT_SCENARIO' and ofsa_tab_columns_v.owner='OFSA_OWNER' order by ofsa_tab_columns_v.display_name

Log on connection to database failed. Database is not accessible.


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