Is there a way to allow SCM user to have access of creating data model using SCM tables?

Question

Is there a way to allow SCM user to have access of creating data model using SCM tables but restricts access of HCM tables?

RVohra · Answer

Hi @User_OJ47U

It is currently not possible to restrict access to the tables.

There is currently an idea

https://cloudcustomerconnect.oracle.com/posts/9c82838cd2

Users having BI admin or BI author roles can query all the tables in Fusion schema from data model. It is not possible to restrict specific tables from BI publisher data model. If you do not want them to query those tables from data model then please unassign BI admin or BI author roles from those users. If they are developers you can assign those roles in Dev environments where real time data not available.

Hope it helps!