Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
User_OJ47U
User_OJ47U Rank 1 - Community Starter
edited Jan 16, 2026 7:25AM in Oracle Fusion AI Data Platform Forum

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

Tagged:

Answers

  • RVohra
    RVohra Mod

    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!