General OBIEE

Get Involved. Join the Conversation.


    Abdul Karim OMAR
    BI publisher custom role
    Topic posted August 26, 2019 by Abdul Karim OMARSilver Medal: 2,000+ Points 
    50 Views, 7 Comments
    BI publisher custom role
    BI publisher custom role

    Can we create a custom role so the user can only have access to new data model for creating SQL queries and not able to edit existing data models, reports and templates?

    This should only to query data from back end.





    • Prateek Parasar

      Check Data Model Developer role inherited by application developer role. If that role has individual privileges for create and edit then for sure otherwise you can’t. You van create custom role using the privileges from this role. 

    • MandeepKGupta

      Hi Abdul,

      Please check below MOS, it has got the details you are looking for:

      Unable To Access BI Reports With Custom Job Role (Doc ID 2110929.1) 


    • Tom Strudley

      One potential way of doing this is to assign the BI Publisher Data Model Developer Role privilege to the custom role and then lock down every existing data model update access to BI Administrator Role only. If that does work you'd need a handover process between the custom role user and administrator to lock the new report down

      • Prateek Parasar

        Good idea. Not sure how feasible it is. Dirty way but still can do the job

        • Tom Strudley

          Yeah it's a tricky one, I'm not a big fan of this approach (although I do like objects to be locked down). But it's the only potential approach I can think of right now, I suppose the privileges were built in this design to leverage in similar situations to this