ACACTACTGP

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 ACACTION_ID column, it forms the primary key.
ACACTION_IDINTEGER NOT NULLThe action ID. It is a foreign key to the ACACTION table. Together with the ACACTGRP_ID column, it forms the primary key.
FIELD1VARCHAR (128)This column is customizable.
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+ACACTION_IDPrimary Key
I0000426ACACTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3ACACTGRP_IDACACTGRPACACTGRP_IDCascade
F_4ACACTION_IDACACTIONACACTION_IDCascade