Read Security Assignments in the Semantic Model

During user login, the Oracle E-Business Suite Data Intelligence semantic model retrieves the user’s security assignments.

Initialization Block

An initialization block reads authorized values from the custom security table. For example,

SELECT SEC_OBJ_MEMBER_NAME
FROM DW_EB_X_OBIA_EBS_CUSTOM_SEC_TABLE
WHERE USERNAME = ':USER'

Session Variable

The initialization block populates a multi-value session variable. For example, ORG_BU; this variable stores the list of authorized security values for the current session.

Data Security Context

The session variable is used to enforce row-level data security within the semantic model. For example,

Dimension	Filter Value
Operating Unit	@ORG_BU