Implementing Row level security Oracle Analytics Cloud Standard edition

User_82I4B

Content

I am planning to implement OAC Std Edition. Have a table with 100k records for 200 customers. Want to build a dashboard with security setup such that each customer only see their data based on the CUSTOMER_ID field in the record.

I was given to understand this is not possible in Standard Edition, has anyone faced such a use case and resolved it?

[Deleted User]

Standard Edition is just DV and you won't be able to do this in the same way as you can in the Enterprise Edition.

Doug Ross

Where will the data be stored? In a dataset?   Probably not possible then.

If it's in a database,  do you have a table that maps a user id to a customer id?

User_82I4B

Yes, we have table which stores mapping of USER_ID to CUSTOMER_ID

User_82I4B

Hi Doug, will you be able to share your views to achieve if the data is stored in a table.

Another point that keeps me wondering, is the performance. Using any workaround, would it have a Performance issue as the user count increases.

User_IYLB4

You can apply filter to your data while creating a new dataflow & then make dataset from that dataflow in OAC-DV itself. After getting the dataset , click on the hamburger icon at the right of the dataset , now click on inspect there u can create Custom Application roles & assign to the respective person. Might be slightly long task but in Std.Edition i think this would help u.