Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Manish Pesswani
    Security In Data Model
    Topic posted May 8, 2017 by Manish PesswaniBronze Medal: 1,250+ Points, tagged BI Publisher, Reporting and Analytics, Sample Reports, Setup/Administration, SQL 
    180 Views, 2 Comments
    Title:
    Security In Data Model
    Summary:
    How to restrict user by not getting data of other BU in BIP Report
    Content:

    Hi Champs,

    Let's say my user 'A' has access to only 'X' Business Unit.

    How should BIP data model be configured so that only 'X' Business unit data is accessed by User 'A' ??

    In Ebiz on premises, we achieve same by using synonyms or initializing sessions

    Comment

     

    • Ilyas Brahmia

      Hello

      In your query, you need to join your tables with one of these two views:

      PER_PERSON_SECURED_LIST_V

      or

      PER_ASSIGNMENT_SECURED_LIST_V

      You can use this post, to better understand what's happening behind Bi security.

      https://cloudcustomerconnect.oracle.com/posts/830e436ad1

      Regards,

      Ilyas

    • mrigank sharma

      HI,

       You can use before report trigger to add MO.INIT('ROLE_NAME') for specific privilege for that report data access.

       

      Regards,

      mrigank