You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Data-level-security & roles

Received Response
edited Nov 6, 2020 10:12AM in Oracle Analytics 1 comment


Manage filters specificaly both BIConsumer and BIServiceAdministrator



We recently implemented data level security in OAC-BI for BIConsumer role, to do so we designed a basic table with user email column (ref to :user) and another one with the filter string (ref to PRODUCT_CODE).

What I want is that filters apply only to my BIConsumer role and not for other roles such BIServiceAdministrator. So the users that are provisioned into BIServiceAdministrator won't have to be specified in the security table.

I tried the following but without success, any best practice to recommend?

Thank you for your help.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!