Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

BI publisher custom role

63
Views
7
Comments
Abdul Karim OAMR
Abdul Karim OAMR Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

BI publisher custom role

Content

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.

Thanks

Karim

Comments

  • Prateek Parasar - GTUK, ACE Pro
    Prateek Parasar - GTUK, ACE Pro Rank 2 - Community Beginner

    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
    MandeepKGupta Rank 1 - Community Starter

    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) 

    Thanks.

  • Prateek Parasar - GTUK, ACE Pro
    Prateek Parasar - GTUK, ACE Pro Rank 2 - Community Beginner

    I don't think there is a way that you can only create new data model but not edit existing ones.

  • Tom Strudley
    Tom Strudley Rank 4 - Community Specialist

    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 - GTUK, ACE Pro
    Prateek Parasar - GTUK, ACE Pro Rank 2 - Community Beginner

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

  • Tom Strudley
    Tom Strudley Rank 4 - Community Specialist

    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

  • Prateek Parasar - GTUK, ACE Pro
    Prateek Parasar - GTUK, ACE Pro Rank 2 - Community Beginner

    I would hope they have seperate privileges for create, view and edit. Should do at most places