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?

1
Views
0
Comments
Jameel Ahmed Ansari
Jameel Ahmed Ansari Rank 2 - Community Beginner

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

1
1 votes

Submitted · Last Updated