9 Replies Latest reply on Jun 8, 2017 2:58 PM by user13795100

    OBIEE ROW LEVEL SECURITY NEXT STEP

    user13795100

      Hello guys, I know the discussion I'm posting is old and made and made and made again;  but I'm trying to do one step more.

      I would like to understand how to technically address a requirement like this:

      Scenario::

      • One USER: USER_1
      • two ROLES: ROLE_1 , ROLE_2
      • Two SJA: SJA_1 / SJA_2
      • Four COUNTRIES: USA,ITA,FRA,UK

       

                  - USER_1 belongs both ROLE_1 and ROLE_2.

       

      - ROLE_1 can access both SJA_1 and SJA_2; but with different row level security.

      It means that:

      ROLE_1 for the SJA_1 can see only the records where COUNTRY in (USA,ITA)

      ROLE_1 for the SJA_2 can see only the records where COUNTRY in (UK,FRA)

       

      - ROLE_2 can access both SJA_1 and SJA_2; but with different row level security.

      It means that:

      ROLE_2 for the SJA_1 can see only the records where COUNTRY in (FRA)

      ROLE_2 for the SJA_2 can see only the records where COUNTRY in (USA)

       

      do you have any idea on how to address this kind of requirement?

       

      thank you

       

      Regards,

       

      antonio