Share this page
KNTA_RESOLVED_SEC_TOKENS
This table stores workflow dynamic security which is derived by evaluating a token. The data for a token can change based on Request Data (for example) and is evaluated and stored into this table so that security queries can run efficiently without evaluating tokens in real-time.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KNTA_SECURITY_GROUPS_NLS |
SECURITY_GROUP_ID |
SECURITY_GROUP_ID |
|
KNTA_USERS |
USER_ID |
USER_ID |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_ENTITIES_NLS |
ENTITY_ID |
ENTITY_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
RESOLVED_SEC_TOKEN_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
ENTITY_PRIMARY_KEY |
NOT NULL |
NUMBER |
Primary ID of the entity, for example the REQUEST_ID if the ENTITY_ID corresponds to a request |
|
ENTITY_ID |
NOT NULL |
NUMBER |
ID of the entity associated with the workflow, for example the Request Entity ID of 20 defined in KNTA_ENTITIES |
|
SECURITY_TYPE_CODE |
NOT NULL |
VARCHAR2(80) |
Either USER_ID or SECURITY_GROUP_ID associated with the TOKEN. |
|
SECURITY_GROUP_ID |
NULLABLE |
NUMBER |
If the SECURITY_TYPE_CODE is SECURITY_GROUP_ID, will store the ID of the Security Group that token was evaluated to. |
|
USER_ID |
NULLABLE |
NUMBER |
If the SECURITY_TYPE_CODE is USER_UD, will store the ID of the User that the token evaluated to. |
|
OBSOLETE_FLAG |
NULLABLE |
VARCHAR2(3) |
Determines whether the record is obsolete (Y/N) |
|
TOKEN |
NULLABLE |
VARCHAR2(1000) |
Name of the token that was setup for workflow security |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KNTA_RESOLVED_SEC_TOKENS_N2 |
NONUNIQUE |
1 |
ENTITY_PRIMARY_KEY |
|
KNTA_RESOLVED_SEC_TOKENS_N2 |
NONUNIQUE |
2 |
ENTITY_ID |
|
KNTA_RESOLVED_SEC_TOKENS_N2 |
NONUNIQUE |
3 |
TOKEN |
|
KNTA_RESOLVED_SEC_TOKENS_N2 |
NONUNIQUE |
4 |
SECURITY_GROUP_ID |
|
KNTA_RESOLVED_SEC_TOKENS_N3 |
NONUNIQUE |
1 |
USER_ID |
|
KNTA_RESOLVED_SEC_TOKENS_N4 |
NONUNIQUE |
1 |
SECURITY_GROUP_ID |
|
KNTA_RESOLVED_SEC_TOKENS_U1 |
UNIQUE |
1 |
RESOLVED_SEC_TOKEN_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KNTA_RESOLVED_SEC_TOKENS_S |
RESOLVED_SEC_TOKEN_ID |
