nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Jameel Ahmed Ansari

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

Find more posts tagged with

Submitted

BI Publisher

OTBI

Status: Submitted

Comments

Adam Liu

Jameel,

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

Thanks,

Adam

Jameel Ahmed Ansari

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

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

Jameel Ahmed Ansari

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

Regards

Jameel