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:

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.


NameColumn NamesType
I0000426ACACTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType