For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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
Comment
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.
Average Rating:



2 ratings
|
Sign in to rate this
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.
Average Rating:



3 ratings
|
Sign in to rate this
I don't think there is a way that you can only create new data model but not edit existing ones.
Average Rating:



1 rating
|
Sign in to rate this
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
Average Rating:



1 rating
|
Sign in to rate this
Good idea. Not sure how feasible it is. Dirty way but still can do the job
Average Rating:



1 rating
|
Sign in to rate this
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
Average Rating:



1 rating
|
Sign in to rate this
I would hope they have seperate privileges for create, view and edit. Should do at most places
Average Rating:



1 rating
|
Sign in to rate this