Restrict BIP (Reports & Analytics) Access to Specific Set of Users

User_Z4C9F

Organization Name

CherryRoad

Description

Restrict BIP (Reports & Analytics) Access to Specific Set of Users. Not all users of financials or hcm are allowed to query the database using create data models and extract the data from Base tables. 

Certain Personal information like bank accounts, PII invformations are available in tables which are accessible to all users with role BI Author/ BI Administrator.

Eg: Supplier bank accounts. 

We have masking utility to mask the bank accounts in front end. But when an hcm user or erp user tries to query the table. The bank account numbers and all PII information are available and visible in BI reports without masking. Due to which anyone has access to BI Publisher can view all sensitive information. 

Need some functionality or role that restricts all users or set of users querying sensitive information. Unlike other Oracle products such as PeopleSoft doesn't allow a PIA user to query a database tables or base tables. 

Restrict set of users with some methodology to restrict BI access(Table level or module level). 

Use Case and Business Need

Security breach if all users can query the base tables and get sensitive information out of BI reports. Set of Users to be restricted to query the Base tables. 

Eg: Not all users with Manager roles are allowed to view Supplier information(using BI Publisher). 

Benefits: Security to be tightened and secure the sensitive information. 

More details

Current product is like an open Pond. Anyone who have BI Author(Role inherited within Parent role) can access  any information using BI Publisher. The querying option to be given only to specific set of users and not to all users from 1 to n. 

Original Idea Number: ef61fc9002