Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: