Share this page

# KNTA_ACCESS_SECURITY_HIST

This table stores access security history. This table is required for SOX audit. The retention of records in this table should be determined by the SOX guidelines for the company.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_ACCESS_GRANTS_NLS | ACCESS_GRANT_ID | ACCESS_GRANT_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | SECURITY_GROUP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ACCESS_SECURITY_HIST_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
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
ACCESS_GRANT_ID | NOT NULL | NUMBER | Indicates the access grant for this record. This value should correspond to the ACCES_GRANT_ID in KNTA_ACCESS_GRANTS
ACCESS_GRANT_NAME | NOT NULL | VARCHAR2(80) | Indicates the access grant name for this record.
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_ACCESS_SECURITY_HIST_N1 | NONUNIQUE | 1 | SECURITY_GROUP_ID
KNTA_ACCESS_SECURITY_HIST_N2 | NONUNIQUE | 1 | ACCESS_GRANT_ID
KNTA_ACCESS_SECURITY_HIST_U1 | UNIQUE | 1 | ACCESS_SECURITY_HIST_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_ACCESS_SECURITY_HIST_S | ACCESS_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: