Insufficient privileges Error While Opening Workbooks By a New User
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Discoverer - Version 10.1.2.0.2 to 10.1.2.3 [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Oct-2013***
Opening the workbook shared to newly created database user, from any Discoverer clients (Viewer, Plus or Desktop) fails with the error message :
Error : ORA-01031 Insufficient privileges /Attempt to open workbook failed.
- The error occurs only for specific worksheet(s).
- The user has granted all Discoverer the privileges to all Business areas and the workbook(s) are shared to him.Also he has granted access to all related tables and views
- Owner of the workbook is able to open it without problems.
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