Oracle Transactional Business Intelligence Idea Lab

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

Ability to view the SQL inside a Data Model but not have edit access to it in OTBI?

92
Views
4
Comments

Organization Name

Bank of Ayudhya

Description

Hi Team,

We are having a group of users who need to access the SQL and review the data model.
But they should not be able to edit and save the SQL.

So I checked via the permissions in the folders and provided the below custom Permissions:
Read
Traverse
Run Publisher Report
Schedule Publisher Report
View Publisher Output

But with these permissions also the user is not able to view the SQL in Data Model.

Use Case and Business Need

Same as Idea Description

More details

We have raised an SR 3-23400224501 and we came to know that there was an ER already which has been rejected. May we know the reason why it is rejected. Can this be taken up?

Below is the response

Hi Guru,

I am not able to edit the KM article but i can see the ER was rejected i can refer the km article author to edit the document.
Can One Provide Read Only Access For BI Publisher Users ( Doc ID 2343119.1 )


Regards
Lokesh

Original Idea Number: c30e35c459

Tagged:
3
3 votes

Submitted · Last Updated

Comments

  • Adam Liu
    Adam Liu Rank 4 - Community Specialist

    Jameel,

    Like the attached screen, you may need to check with Oracle why BIP Permission doesn't work as expected.

    Thanks,

    Adam

    86.PNG

  • Jameel Ahmed Ansari
    Jameel Ahmed Ansari Rank 2 - Community Beginner

    Yeah Thanks Adam. We discussed this through and SR. But eventually we came to know that this feature is not supported and we were told to raise and Idea.

     

    Regards

    Jameel

  • Adam Liu
    Adam Liu Rank 4 - Community Specialist

    Thanks Jameel. Hopefully CX Sales & B2B Service can honor BIP permissions soon. 

  • Jameel Ahmed Ansari
    Jameel Ahmed Ansari Rank 2 - Community Beginner

    Not sure if someone from OBIEE team has noticed this? Appreciate if we can get a response to this.

    Regards

    Jameel