Oracle Analytics Cloud and Server
Implementing Row level security Oracle Analytics Cloud Standard edition
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?
Answers
-
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.
-
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?
-
Yes, we have table which stores mapping of USER_ID to CUSTOMER_ID
-
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.
-
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.
