1 2 Previous Next 23 Replies Latest reply on Aug 9, 2016 9:55 PM by Manoj Dixit

    Defining Data Security: Identity Manager or LTS?

    Manoj Dixit

      Hi,

       

      We are on OBI EE 11.1.1.7.0.

       

      I would like to know the best place to define and maintain data security within an Oracle BI RPD file. I need to restrict data based on user groups, for example, members of group G1 can only view region Americas data, while members of group G2 can view region Europe data only.

       

      At the moment, the data security is implemented in the LTSs of logical fact tables (Content tab > WHERE clause). However, we can define the data security using Identity Manager, as well, in an Oracle BI RPD file.

       

      Could you let us know the pros and cons of the above two approaches or the best practices to be followed, please?

       

      Thank you.

       

      Regards,

       

      Manoj.

        1 2 Previous Next