How to restrict access to audit tables in fusion HCM

Question

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

Simon Ng · Answer

The same question is being asked across the Oracle products to no avail.

Restriction of Data in reports and analytics while creating Data Model

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."

Gianni Ceresa · Answer

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/

Thimmaiah CP-Oracle · Answer

Thanks for this Arjun, my question is more about how to restrict the access to tables in fusion HCM BIP.

Thanks,

Thimmaiah