My Oracle Support Banner

Non-Admin Users Unable To Execute Direct Database Requests (Doc ID 2746916.1)

Last updated on FEBRUARY 02, 2021

Applies to:

Oracle Analytics Cloud - Version 105.1.0 and later
Oracle Analytics Cloud - Classic - Version 105.1.0 and later
Information in this document applies to any platform.

Symptoms

Followed the OAC Guide to grant below privileges to Non-Admin users to Issue Direct Database requests :

Assign "Execute Direct Database Analysis" privilege to the BIConsumer role
Assign "Edit Direct Database Analysis" and "Execute Direct Database Analysis" privilege to the BIAuthor role.

Below error displayed while accessing the DDR report which is embedded in the Dashboard :

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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