Oracle Fusion BI Publisher Custom Physical SQL Security
SummaryOracle Fusion BI Publisher Custom SQL - Security Considerations
When you create a Business Intelligence Publisher data model with physical SQL, you have two options.
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.