ACPOLGRP

This table stores all the access control policy groups in the system. Each row in this table represents a policy group.

Column Descriptions:

NameTypeDescription
ACPOLGRP_IDINTEGER NOT NULLThe generated unique ID of this access control policy group record.
NAMEVARCHAR (128) NOT NULLThe name of the access control policy group.
MEMBER_IDBIGINT NOT NULLThe member ID of the owner of the access control policy group. It is a foreign key to the MEMBER table.
OPTCOUNTERSMALLINTThe 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>ACPOLGRP_IDPrimary Key
I0000306NAME+MEMBER_IDUnique Index
I0000439MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1005MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1006ACPOLGRP_IDACPOLSUBGPPARENT_IDCascade
F_1007ACPOLGRP_IDACPOLSUBGPCHILD_IDCascade
F_1009ACPOLGRP_IDACPLGPDESCACPOLGRP_IDCascade
F_1011ACPOLGRP_IDACPOLGPPOLACPOLGRP_IDCascade
F_1012ACPOLGRP_IDACPLGPSUBSACPOLGRP_IDCascade