ACATTRDESC

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:

Name Type Description
ACATTR_ID BIGINT NOT NULL The attribute ID. It is a foreign key to ACATTR table. Together with the LANGUAGE_ID column in this table, it forms a primary key.
DISPLAYNAME VARCHAR (254) NOT NULL The locale-specific display name for this attribute.
DESCRIPTION VARCHAR (254) The description of this attribute.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. Together the ACATTR_ID column, it forms a primary key.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> ACATTR_ID+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_10 ACATTR_ID ACATTR ACATTR_ID Cascade
F_9 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference
Access control data model