ITG_SECURABLE_ENTITIES

This table stores the securable entities, that is, entities that have associated access control lists.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

SECURABLE_ENTITY_ID

NOT NULL

NUMBER

Indicates the ID of the securable entity. This is referenced by the ACCESS_CONTROL_ENTRY_ID column in ITG_ACCESS_CONTROL_ENTRIES.

ENTITY_TYPE_CODE

NOT NULL

VARCHAR2(255)

Indicates the type of entity being referenced

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 a 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 a record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201542

UNIQUE

1

SECURABLE_ENTITY_ID

Sequences

Sequence Name

Sequence Type

ITG_SECURABLE_ENTITIES_S

SECURABLE_ENTITY_ID