Insufficient privileges Error While Opening Workbooks By a New User
(Doc ID 945477.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!