BI Publisher offers integration with Oracle Database security to enable you to administer the BI Publisher users with your Oracle Database users.
Follow these procedures to integrate BI Publisher with Oracle E-Business Suite:
Note:
For information on setting up Oracle Database security, see Oracle Database Security Guide.
When you restart the server, the roles to which BI Publisher roles have been assigned are visible as roles in the BI Publisher security center.
You can create roles in the Oracle database that correspond to BI Publisher functional roles.
To view a report generated from a particular data source, a report consumer's role must be granted access to the data source.
Similarly, to create a data model based on a particular data source, the report author's role must be granted access to the data source.
To grant a role access to a data source:
For a role to access objects in a folder, you must grant the role permissions to the catalog object.
You can grant permissions at the folder level, so that a role has the same access to every object in a folder, or you can assign access individually to each object in a folder.
See the following sections for more information:
To grant catalog permissions to a role: