KNTA_USER_SECURITY_HIST

This table stores user security history. This table is used for the purpose of Sarbanes-Oxley (SOX) compliance. If you comply with SOX, check with your SOX auditor to see how long you need to retain the records before you truncate the table. If you do not comply with SOX, you do not need to back up the table, and truncating the table does not impact the application.

Foreign Keys

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

Column Descriptions

Column Name	Null?	Data Type	Description
USER_SECURITY_HIST_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date the record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date the record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
SECURITY_GROUP_ID	NOT NULL	NUMBER	Indicates the security group for this record. This value should correspond to the SECURITY_GROUP_ID in KNTA_SECURITY_GROUPS
SECURITY_GROUP_NAME	NOT NULL	VARCHAR2(200)	Indicates the security group name
USER_ID	NOT NULL	NUMBER	Indicates the user for this record. This value should correspond to the USER_ID in KNTA_USERS
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)	Indicates the source type code for this record
SOURCE	NULLABLE	VARCHAR2(100)	Indicates the source for this record
EVENT_CODE	NOT NULL	VARCHAR2(20)	Indicates the event code for this record

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_USER_SECURITY_HIST_N1	NONUNIQUE	1	SECURITY_GROUP_ID
KNTA_USER_SECURITY_HIST_N2	NONUNIQUE	1	USER_ID
KNTA_USER_SECURITY_HIST_U1	UNIQUE	1	USER_SECURITY_HIST_ID

Sequences

Sequence Name	Sequence Type
KNTA_USER_SECURITY_HIST_S	USER_SECURITY_HIST_ID