Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to view the SQL inside a Data Model but not have edit access to it in OTBI?

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