The Oracle Fusion Middleware security model includes three roles:
- BIAdministrator: allows user to configure and manage the Oracle Business Intelligence installation. Any user assigned to this role also receives the BIAuthor and BIConsumer roles.
- BIAuthor: allows user to create and edit content for other users to see and use. Any user assigned to this role also receives the BIConsumer role.
- BIConsumer: allows user to see or use content created by other users.
Users need the BIConsumer role to use reports in BI Publisher. Before you grant the BIConsumer role, add the JDBC data source to the BIConsumer role.
To assign the JDBC data source to the BIConsumer role:
- Log in to BI Publisher as an administrative user.
- Click the Administration link.
- Under Security Center, select Roles and Permissions.
- Select Add Data Source to the BIConsumer role.
- Under Database Connections, move the JDBC data source created for P6 from the Available Data Sources to the Allowed Data Sources.
- Select Apply.