FUN_DS_GRANTS_UPG_AUDIT
This table contains grants information that maps to the identified data roles in the data role audit table during upgrade. It is a persistent table.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FUN_DS_GRANTS_UPG_AUDIT_PK |
GRANTS_UPG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GRANTS_UPG_ID | NUMBER | 18 | Yes | Record identifier for data role grants upgrade entity. | |
| GRANT_GUID | VARCHAR2 | 32 | Yes | Global unique identifier of the grants record in FND_GRANTS. | |
| ENTERPRISE_ID | NUMBER | 18 | Yes | Enterprise identifier. Used in partitioning for multiple tenancy. | |
| SANDBOX_ID | VARCHAR2 | 64 | Yes | Unique identifier for sandbox. | |
| ROLE_NAME | VARCHAR2 | 256 | Yes | Role name of grant key when recipient of the grant is a role. | |
| OBJECT_NAME | VARCHAR2 | 80 | Yes | FND object name for data security. | |
| INSTANCE_TYPE | VARCHAR2 | 30 | Yes | Type of grant. Possible values are Instance, Set and Global. | |
| INSTANCE_SET_NAME | VARCHAR2 | 60 | Name of the instance set grant. | ||
| INSTANCE_PK_VALUE1 | VARCHAR2 | 256 | Value of the primary key for dimension table. | ||
| INSTANCE_PK_VALUE2 | VARCHAR2 | 256 | Value of the primary key for dimension table. | ||
| INSTANCE_PK_VALUE3 | VARCHAR2 | 256 | Value of the primary key for dimension table. | ||
| INSTANCE_PK_VALUE4 | VARCHAR2 | 256 | Value of the primary key for dimension table. | ||
| INSTANCE_PK_VALUE5 | VARCHAR2 | 256 | Value of the primary key for dimension table. | ||
| PARAMETER1 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER2 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER3 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER4 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER5 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER6 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER7 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER8 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER9 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| PARAMETER10 | VARCHAR2 | 256 | Parameter for data security dimension. | ||
| MENU_ID | NUMBER | 18 | Unique menu identifier associated with data security privilege. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_DS_GRANTS_UPG_AUDIT_U1 | Unique | Default | GRANTS_UPG_ID |
| FUN_DS_GRANTS_UPG_AUDIT_U2 | Unique | Default | GRANT_GUID, ENTERPRISE_ID, SANDBOX_ID |