This table contains the assignments of a user , role and data security context.
Module:
USER_ROLE_DATA_ASSIGNMENT_ID
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, 2022, Oracle and/or its affiliates.