Data-level-security & roles
SummaryManage 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.