Business Intelligence Publisher Secured List Views
Oracle Business Intelligence Publisher is a set of tools for creating formatted reports based on data models. You can access Business Intelligence Publisher from Business Intelligence Composer or the Business Intelligence Catalog by clicking New from the Report menu.
This topic describes how you can use secured list views to secure access to data in Business Intelligence reports. Some reporting tools combine the data model, layout, and translation in one report file. With that approach, business-intelligence administrators must maintain multiple copies of the same report to support minor changes. By contrast, Business Intelligence Publisher separates the data model, layout, and translation. Therefore, reports can be:
-
Generated and consumed in many output formats, such as PDF and spreadsheet
-
Scheduled for delivery to email, printers, and so on
-
Printed in multiple languages by adding translation files
-
Scheduled for delivery to multiple recipients
Business Intelligence Publisher Data Security and Secured List Views
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.
The following tables show, for each database table:
-
The secured list view
-
The data security privilege required to report on data in the table, if it's accessed using the secured list view
These duty roles have the privileges shown in the following table:
-
Absence Management Transaction Analysis
-
Payroll Transaction Analysis
-
Vacancy Transaction Analysis
-
Workforce Transaction Analysis
Table |
Secured List View |
Data Security Privilege |
---|---|---|
HR_ALL_ORGANIZATION_UNITS_F |
PER_DEPARTMENT_SECURED_LIST_V |
Report Department Data |
HR_ALL_POSITIONS_F |
PER_POSITION_SECURED_LIST_V |
Report Position Data |
PER_JOBS_F |
PER_JOB_SECURED_LIST_V |
Report HR Job Data |
PER_LOCATIONS |
PER_LOCATION_SECURED_LIST_V |
Report Location Data |
PER_GRADES_F |
PER_GRADE_SECURED_LIST_V |
Report Assignment Grade Data |
These duty roles have the privileges shown in the following table:
-
Documents of Record Transaction Analysis
-
Payroll Transaction Analysis
-
Workforce Transaction Analysis
Table |
Secured List View |
Data Security Privilege |
---|---|---|
PER_ALL_PEOPLE_F |
PER_PERSON_SECURED_LIST_V |
Report Person Data |
PER_PERSONS |
PER_PUB_PERS_SECURED_LIST_V |
Report Person Deferred Data |
The Payroll Transaction Analysis duty role has the privileges shown in this table.
Table |
Secured List View |
Data Security Privilege |
---|---|---|
HR_ALL_ORGANIZATION_UNITS_F |
PER_LEGAL_EMPL_SECURED_LIST_V |
Report Legal Employer Data |
PER_LEGISLATIVE_DATA_GROUPS |
PER_LDG_SECURED_LIST_V |
Report Legislative Data Group Data |
PAY_ALL_PAYROLLS_F |
PAY_PAYROLL_SECURED_LIST_V |
Report Payroll Definition Data |
The Compensation Transaction Analysis duty role has the privilege shown in this table.
Table |
Secured List View |
Data Security Privilege |
---|---|---|
CMP_SALARY |
CMP_SALARY_SECURED_LIST_V |
Report Salary Data |
The Human Resource Analyst job role has the privilege shown in this table.
Table |
Secured List View |
Data Security Privilege |
---|---|---|
PER_ALL_ASSIGNMENTS_M |
PER_ASSIGNMENT_SECURED_LIST_V |
Report Assignment Data |
You can find details of the secured list views in the Tables and Views for Oracle HCM Cloud guide on the Oracle Help Center.