KNTA_APPLET_KEYS

This is a temporary table that stores a one-time key that is used to automatically authenticate workbench users accessing web pages such as reports, attachments, and logs. This mechanism prevents workbench users from having to enter their logon information twice in a secure way.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
APPLET_KEY_ID	NOT NULL	NUMBER	System-generated identifier
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATED_DATE	NOT NULL	DATE	Date record was last updated
APPLET_KEY	NULLABLE	NUMBER	One-time key to allow web authentication

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_APPLET_KEYS_U1	UNIQUE	1	APPLET_KEY_ID

Sequences

Sequence Name	Sequence Type
KNTA_APPLET_KEYS_S	APPLET_KEY_ID