DW_USER_ROLE_DATA_ASGNMNTS_D

This table contains the assignments of a user , role and data security context.

Details

Module:

Key Columns

USER_ROLE_DATA_ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
USER_ROLE_DATA_ASSIGNMENT_ID NUMBER 38 0 True Record identifier for the user role data assignment.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier.    
USER_GUID VARCHAR2 128     Record identifier for the corresponding entry for the user in Oracle Identity Management.    
ROLE_NAME VARCHAR2 512     Role name that includes the grantee key as the recipient of the role grants. Role grant is the job role associated with the user.    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
LEDGER_ID NUMBER 38 0   Record identifier for the ledger the user data role can access.    
BOOK_ID NUMBER 38 0   Record identifier for the asset book the user data role can access.    
SET_ID NUMBER 38 0   Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.    
INV_ORGANIZATION_ID NUMBER 38 0   Record identifier for the inventory organization the user data role can access.    
CST_ORGANIZATION_ID NUMBER 38 0   Record identifier for the cost organization the user data role can access.    
ITM_ORGANIZATION_ID NUMBER 38 0   Record identifier for the item organization the user data role can access.    
ACCESS_SET_ID NUMBER 38 0   Record identifier for the data access set the user data role can access.    
CONTROL_BUDGET_ID NUMBER 38 0   Record identifier for the control budget the user data role can access.    
INTERCO_ORG_ID NUMBER 38 0   Record identifier for the intercompany organization the user data role can access.    
PRJ_ORGANIZATION_ID NUMBER 38 0   Record identifier for the project organization the user data role can access.    
MFG_ORGANIZATION_ID NUMBER 38 0   Record identifier for the manufacturing organization the user data role can access.    
DATASEC_CONTEXT_TYPE_CODE VARCHAR2 32     Security context of the data access assignments, such as business unit or ledger.    
DATASEC_CONTEXT_VALUE1 VARCHAR2 64     Security context value of the data access assignments.    
DATASEC_CONTEXT_VALUE2 VARCHAR2 64     Security context value of the data access assignments.    
DATASEC_CONTEXT_VALUE3 VARCHAR2 64     Security context value of the data access assignments.    
DATASEC_CONTEXT_VALUE4 VARCHAR2 64     Security context value of the data access assignments.    
DATASEC_CONTEXT_VALUE5 VARCHAR2 64     Security context value of the data access assignments.    
START_DATE_ACTIVE DATE       Date at the beginning of the date range within which the row is active.    
ACTIVE_FLAG VARCHAR2 16     Indicates the state of the data role assignment. Possible values are Y for active and N for not active.    
RECORD_TYPE_CODE VARCHAR2 32     Code to indicate whether the record is migrated, seeded or defined by the user.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATE_LOGIN VARCHAR2 64     Who column: indicates the session login associated to the user who last updated the row.    

Copyright © 2019, 2023, Oracle and/or its affiliates.