You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle Fusion BI Publisher Custom Physical SQL Security

Received Response
edited Sep 16, 2019 7:45PM in Reporting and Analytics for ERP 5 comments


Oracle Fusion BI Publisher Custom SQL - Security Considerations




When you create a Business Intelligence Publisher data model with physical SQL, you have two options.

You can:

  • Select data directly from a database table, in which case the data you return isn't subject to data-security restrictions. Because you can create data models on unsecured data, you're recommended to minimize the number of users who can create data models.

  • Join to a secured list view in your select statements. The data returned is determined by the security profiles that are assigned to the roles of the user who's running the report.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!