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 |