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 | This column is for Oracle Internal use only. 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, 2024, Oracle and/or its affiliates.