Oracle Analytics and AI

Drew G

In production we limit the folks that have administrator access; however, we have support staff that helps troubleshoot issues before they get to an application administrator. To make those folks more effective, we need to grant them a view, inquire and reporting equivalent of system administrator. While working on building out the roles to support this, we were told that oracle doesn't allow view only access to the BI Publisher Administration pages.
The current issue was determining the actual SFTP site that is behind one of the configured FTP output options that the end user can select.

Jayant Ajayrao Deshmukh

Creating a view-only or inquiry-based access to Oracle BI Publisher Administration pages can be challenging because Oracle Fusion does not natively support view-only roles for BI Publisher Administration functions. However, you can take a couple of alternative approaches to allow support staff to access relevant information without granting full admin rights.

Custom BI Publisher Inquiry Role:

1. While Oracle does not allow a pure view-only role for BI Publisher Administration pages, you can still create a custom role with selective permissions to specific BI Publisher functions that support staff may need.
2. Steps:
   1. Navigate to the Security Console in Oracle Fusion.
   2. Create a custom role (e.g., "BI Publisher Inquiry Role").
   3. Add relevant duty roles to this custom role:
      • BI Consumer Role: Grants access to view BI Publisher reports.
      • BI Publisher Data Model Developer Role: Grants access to the Data Model section, enabling view-only access to data sources (though this doesn’t grant access to the full Administration console).
   4. Test the role to ensure support staff can view reports and data models without edit access.