Error or No Data When Connecting to Discoverer Plus/Viewer 10.1.2 When Privileges Granted Via Role

(Doc ID 797119.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Discoverer - Version: 10.1.2.1 to 10.1.2.3 - Release: 10.1.2 to 10.1.2
Oracle Discoverer - Version: 10.1.2.1 to 10.1.2.3   [Release: 10.1.2 to 10.1.2]
Information in this document applies to any platform.

Symptoms

When connecting to Discoverer 10.1.2 Plus or Viewer, the following error occurs:

"You don't have the privileges to create or run workbooks. Please contact your Discoverer manager."


In some cases, users can connect to Discoverer Plus or Viewer, but get no data returned when running workbooks.



Changes

The Discoverer Desktop and Plus privileges (except "Schedule Workbooks") are granted to a database role or application responsibility, rather than granted specifically to users.

Cause

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