Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Row level data security for Local Subject area with auto caching or dataflow based saved dataset

Received Response
43
Views
4
Comments
Rupak C
Rupak C Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

Can you please tell me how Row level data security works when Local Subject area with automatic caching or data flow based saved dataset is used in visualization.

  • When we do it on live data or from a subject area directly in Fusion Data Intelligence, fusion application-based access group security is taken care in FDI so user can see only those opportunities what they have access to.
  • But if I create a data set by joining subject areas and use automatic caching and a refresh schedule, and then sales users use visualization built using that dataset – how that row level data security is honoured?
  • Same question if I create a data flow to pre process data into a file saved in Dataset storage / object storage and then create visualization from there ?
Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited Nov 23, 2024 12:37AM

    HI @Rupak C

    In General We will implement the rowlevel security using SME/RPD, Data base level (Roles).

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/work-row-level-security.html#GUID-108274FC-57F4-42BE-93D2-CBD52CBDF7DD

    What is your source for dataset or dataflow? means are you using file based or DB based?

    Did you tried :

    Dataflows -> dataflowname --> inspect --> Access --> Roles.

    Regards,

    Arjun

  • Rupak C
    Rupak C Rank 3 - Community Apprentice

    Hi,

    We are using CX - Opportunity and CX - Opportunity Revenue Line subject areas available in FDI to source data from the connected sales cloud instance.
    my questions is -

    if Sales Manager A can see 10 Oppties in Sales Cloud, he can see 10 oppties in FDI using CX - Opportunity SA by default.
    if Sales Manager B can see 20 Oppties in Sales Cloud, he can see 20 oppties in FDI using CX - Opportunity SA by default.

    as OOTB data secuity from fusion is covered. so far so good.

    now, if i create a local subject area dataset using CX - Opportunity SA and use automatic caching and refresh that every 5 hours, the cache will contain
    say 500 oppties (all oppties from the sales cloud system) i assume ?

    if i create a visualization using that cached dataset and have sales manager A and Sales Manager B use those visualizations - how many oppties they will see
    by default ?

    all 500 Oppties or 10/20 respectively ?

    Regards-
    Rupak

  • Hitesh Patel-Oracle
    Hitesh Patel-Oracle Mod

    Hi Rupak,

    If the local subject area (LSa) is built using the OOTB subject area, the row level security of OOTB SA will apply in LSA as well.

    So, if the Sales Manager are seeing 10/20 oppties in CX - Oppty SA in FDI, you will also see the same in LSA built against the same SA.

  • Rupak C
    Rupak C Rank 3 - Community Apprentice

    Thanks Hitesh