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