ACPOLGPPOL

This table stores the association between access control policy groups and access control policies. An access control policy that belongs to a policy group will be applied to all the organizations that subscribe to that policy group.

Column Descriptions:

NameTypeDescription
ACPOLICY_IDINTEGER NOT NULLThe ID of the access control policy. It is a foreign key to the ACPOLICY table.
ACPOLGRP_IDINTEGER NOT NULLThe ID of the access control policy group to which the access control policy belongs. It is a foreign key to the ACPOLGRP 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>ACPOLICY_ID+ACPOLGRP_IDPrimary Key
I0000438ACPOLGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1010ACPOLICY_IDACPOLICYACPOLICY_IDCascade
F_1011ACPOLGRP_IDACPOLGRPACPOLGRP_IDCascade