Hi All,
We have a certain requirement to restrict access to audit tables like "CMP_SALARY_". People with only specified roles/permissions should be able to query this table. Is there anyway or workaround to restrict access like this?
Thanks,
Thimmaiah
Thanks for this Arjun, my question is more about how to restrict the access to tables in fusion HCM BIP.
Thanks,
Thimmaiah
I believe you are taking the problem from the wrong direction...
Publisher doesn't have a "per table" privileges feature. Because tables aren't Publisher objects. You can grant access to connections, you can allow users to use data models, but you can't grant or deny access to a database table. Because that is controlled by the credentials you used to connect to the data source.
And maybe you should ask that question in the Fusion HCM forum, because you are asking how to control access to Fusion objects, but Publisher is just "the client" accessing all your credentials can see: https://community.oracle.com/customerconnect/
The same question is being asked across the Oracle products to no avail.
Data Source Access across Oracle Pillars (HCM and FIN) - BI Admin
Restrict BIP access (table access) for person, sensitive data
Restricting access to tables while creating data model in HCM
Restricting access to tables with a privillege in the BI Publisher Data Model Developer Role.
Doc ID 2819026.1, "…it is not possible to restrict BI Publisher Data Models to specific tables."
