FND_SESSION_ROLE_SETS
This table contains combinations of roles formed as sets, which are associated with users who have signed into the applications. Grouping is done for performance related reasons and this table is meant for internal use only.
Details
-
Schema: SESSIONS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FND_SESSION_ROLE_SETS_PK1 |
SESSION_ROLE_SET_KEY, ROLE_GUID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SESSION_ROLE_SET_KEY | VARCHAR2 | 64 | Yes | ROLE_SET_KEY | |
| ROLE_GUID | VARCHAR2 | 64 | Yes | ROLE_GUID | |
| ROLE_NAME | VARCHAR2 | 2000 | ROLE_NAME | ||
| LAST_CONNECT | DATE | LAST_CONNECT |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSION_ROLE_SETS_N1 | Non Unique | Default | SESSION_ROLE_SET_KEY, ROLE_NAME |
| FND_SESSION_ROLE_SETS_N2 | Non Unique | Default | LAST_CONNECT |
| FND_SESSION_ROLE_SETS_U1 | Unique | Default | SESSION_ROLE_SET_KEY, ROLE_GUID, ENTERPRISE_ID |