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.