Oracle® Business Intelligence Applications Installation and Configuration Guide > Integrated Security for Oracle BI Applications >
Initialization Blocks and Security-Related Information in Oracle BI
In the Oracle Business Intelligence repository, the initialization blocks are set up for obtaining a given user's primary position, primary organization, and the owner ID. There are five initialization blocks, as follows: - Primary Position ID
This initialization block obtains the primary position of the given user, based on the user's login, and populates the variable PRIMARY_POSTN_ID. The SQL used by the block is run against the transactional database, and therefore reflects real-time position ID information.
- Primary Owner ID
This initialization block obtains the owner ID for the given user. It obtains this information from the transactional database and populates the PR_OWNER_ID variable.
- Orgs for Org-based Security
This initialization block obtains the list of organizations that a given user belongs to from the transactional database. The variable populated is ORGANIZATION.
- User Hierarchy Level
This initialization block obtains the fixed hierarchy level of the given user, based on the user's login, from W_POSITION_DH. It populates the variable HIER_LEVEL. The SQL used by the block is run against the data warehouse, and therefore reflects the hierarchy level after the last ETL run that populated this table (W_POSITION_DH).
- Authorization
This initialization block is used to associate users with all Security groups to which they belong. The association is based on the variable HIER_LEVEL, which is defined in the User Hierarchy Level initialization block, for the Hierarchy Level security groups, and on the table S_PER_RESP for the Primary Position based Security group. Therefore, User Hierarchy Level is a precedent to Authorization.
|