Custom Security Assignment Table in Autonomous AI Lakehouse

The security framework uses a custom security assignment table stored in Autonomous AI Lakehouse.

Table Name

The DW_EB_X_OBIA_EBS_CUSTOM_SEC_TABLE table stores user-level security assignments for the Oracle E-Business Suite Data Intelligence semantic model. The security assignment information flows directly from the Oracle E-Business Suite source system. This table acts as the central repository for maintaining security mappings across supported dimensions.

Supported Security Dimensions

Examples include:

• Operating Unit
• Business Unit
• Legal Entity
• Ledger

Sample Columns

Sample columns are:

Column	Description
USERNAME	User login identifier
SEC_OBJ_CODE	Security dimension code
SEC_OBJ_MEMBER_VAL	Security object value
SEC_OBJ_MEMBER_NAME	Security object name

Example Security Assignments

Review these example security assignments:

USERNAME	SECURITY OBJECT	ACCESS
[e-mail]	Operating Unit	Vision Germany
[e-mail]	Business Unit	Vision Services
[e-mail]	Legal Entity	Vision Europe
[e-mail]	Ledger	Vision US Ledger

Note:

• Oracle-delivered Data Augmentation Scripts extract security assignment information from Oracle E-Business Suite.
• You maintain and manage security assignments in the security table.
• You can extend the framework to support additional custom security dimensions.