ITG_ACCESS_CONTROL_ENTRIES

This table stores the access control lists associated with securable entities.

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

ACCESS_CONTROL_ENTRY_ID

NOT NULL

NUMBER

Specifies the securable entity with which the specified security privileges are associated. Must match a SECURABLE_ENTITY_ID in ITG_SECURABLE_ENTITIES.

PRIVILEGE_VALUES

NULLABLE

VARCHAR2(255)

Indicates the security privileges that are granted to the specified user or security group.

USER_ID

NULLABLE

NUMBER

Indicates the user to which the specified security privileges are granted. Must match a USER_ID in KNTA_USERS.

SECURITY_GROUP_ID

NULLABLE

NUMBER

Indicates the security group to which the specified security privileges are granted. Must match a SECURITY_GROUP_ID in KNTA_SECURITY_GROUPS

IS_MANAGER_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether the specified user is a manager of the entity with which this access control entry is associated

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

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_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

FKFFB8FDD6C55496FA_I

NONUNIQUE

1

USER_ID

FKFFB8FDD6FE01C679_I

NONUNIQUE

1

SECURITY_GROUP_ID

SYS_C005201531

UNIQUE

1

ACCESS_CONTROL_ENTRY_ID

Sequences

Sequence Name

Sequence Type

ITG_ACCESS_CONTROL_ENTRIES_S

ACCESS_CONTROL_ENTRY_ID