Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Implementing Row level security Oracle Analytics Cloud Standard edition

Received Response
71
Views
5
Comments
Rank 1 - Community Starter

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

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.

  • Rank 6 - Analytics Lead

    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?

  • Rank 1 - Community Starter

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

  • Rank 1 - Community Starter

    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.

  • Rank 3 - Community Apprentice

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.