ACACGPDESC

This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.

Column Descriptions:

NameTypeDescription
ACACTGRP_IDINTEGER NOT NULLThe action group ID. It is a foreign key to the ACACTGRP table. Together with the LANGUAGE_ID column, it forms a unique key.
DISPLAYNAMEVARCHAR (700) NOT NULLThe locale specific display name for this resource group.
DESCRIPTIONVARCHAR (700)The locale specific description for this action group.
LANGUAGE_IDINTEGER NOT NULLForeign key to the LANGUAGE table. Together with the ACACTGRP_ID column, it forms a primary key. For a list of language components, see the LANGUAGE table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACACTGRP_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_2ACACTGRP_IDACACTGRPACACTGRP_IDCascade