ACPOLGRP

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

Column Descriptions:

Name	Type	Description
ACPOLGRP_ID	INTEGER NOT NULL	The generated unique ID of this access control policy group record.
NAME	VARCHAR (128) NOT NULL	The name of the access control policy group.
MEMBER_ID	BIGINT NOT NULL	The member ID of the owner of the access control policy group. It is a foreign key to the MEMBER table.
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>	ACPOLGRP_ID	Primary Key
I0000306	NAME+MEMBER_ID	Unique Index
I0000439	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1005	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1006	ACPOLGRP_ID	ACPOLSUBGP	PARENT_ID	Cascade
F_1007	ACPOLGRP_ID	ACPOLSUBGP	CHILD_ID	Cascade
F_1009	ACPOLGRP_ID	ACPLGPDESC	ACPOLGRP_ID	Cascade
F_1011	ACPOLGRP_ID	ACPOLGPPOL	ACPOLGRP_ID	Cascade
F_1012	ACPOLGRP_ID	ACPLGPSUBS	ACPOLGRP_ID	Cascade

Related reference
Access control data model