Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
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?
User_OJ47U
Rank 1 - Community Starter
Is there a way to allow SCM user to have access of creating data model using SCM tables but restricts access of HCM tables?
0
Answers
-
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!
0
