Categories
- All Categories
- Oracle Analytics Learning Hub
- 18 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 228 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 85 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Restrict BIP access (table access) for person, sensitive data
When creating or editing a data model it should be possible to restrict data access to certain tables that contain person sensitive data such as Ethnicity etc. The security should be applied to data model access as well similar to the access via the UI.
Comments
-
Hello Vina,
Please use secured views tables in BIP report which will restrict data according to thier security permissions
0 -
It seems the original question is about whether we can restrict report writers (specifically, those with the BI Publisher Data Model Developer role) from accessing certain tables.
According to Doc ID 2819026.1, "…it is not possible to restrict BI Publisher Data Models to specific tables."The documentation also suggests using secured views, but this approach only applies to front-end users with the BI Consumer Role, who run and view reports. Our goal, however, is to limit developers from querying certain tables when creating data models with SQL.
The same question is being asked across the Oracle products to no avail.
Restriction of Data in reports and analytics while creating Data Model
GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI Admin
Restricting access to tables with a privillege in the BI Publisher Data Model Developer Role.
Restricting access to tables while creating data model in HCM
Restrict BIP access (table access) for person, sensitive data
Related knowledge articles
0 -
Hi @user10597052,
There is no way to restrict the access only to certain tables for a specific user. If a user has access to any table, he/she will get access to all the tables.
However, in HCM, there are few tables which are marked as sensitive data which will not retrun any data if the user doesn't have appropriate security/role privileges.
Please check below link for list of objects included in sensitive data:
Thanks.
0
