1. Securing ERP
  2. View Reporting Roles and Permissions

View Reporting Roles and Permissions

Viewing reporting roles and permissions can help you to understand how Oracle Transactional Business Intelligence security works.

This topic explains how to view:

  • The reporting roles that a job role inherits

  • The permissions for sample Oracle Transactional Business Intelligence reports in the Business Intelligence Catalog

Viewing Inherited Reporting Roles on the Security Console

Sign in with the IT Security Manager job role and follow these steps:

  1. Select Navigator > Tools > Security Console.

  2. On the Security Console, search for and select a job role. For example, search for and select the Project Manager job role.

    Depending on the enterprise setting, either a graphical or a tabular representation of the role appears. Switch to the tabular view if it doesn't appear by default.

    Project Manager inherits many duty roles, such as Project Plan Management and Project Budget Management. These roles (without the word Duty in their names) are Projects roles. Their role codes start with the characters ORA_. Find these roles in the table.

    Notice also that Project Planning Transaction Analysis Duty roles (with the word Duty in their names) appear in the view. For example, Project Manager inherits the Project Management Duty. These roles are OBI roles. Their role codes start with the characters FBI_. Find these roles in the table.

    Notice that the Project Management Analysis duty role inherits BI Consumer Role. Most of the OBI duty roles inherit BI Consumer Role.

Tip: You can export the role hierarchy to a spreadsheet for offline review.

Viewing Permissions in the Business Intelligence Catalog

To view these permissions, you must have a role that inherits BI Administrator Role. None of the predefined Projects job roles inherits BI Administrator Role.

  1. Select Navigator > Tools > Reports and Analytics to open the Reports and Analytics work area.

  2. In the Contents pane, click the Browse Catalog icon. The Business Intelligence Catalog page opens.

  3. In the Folders pane, expand Shared Folders > Projects > Project Billing. The reports are listed.

  4. Select Preview Invoice Report and click More > Permissions.

  5. View the permissions.