ACRESGRP

This table stores all the access control resource groups in the system. The conditions column stores an XML document containing the constraints and attribute value pairs used for grouping the resources.

Column Descriptions:

Name	Type	Description
ACRESGRP_ID	INTEGER NOT NULL	The resource group ID.
MEMBER_ID	BIGINT NOT NULL	The foreign key to the MEMBER table for the owner of this resource group. All resource groups should be owned by the root organization.
GRPNAME	VARCHAR (254) NOT NULL	The name of the resource group.
DESCRIPTION	VARCHAR (254)	Reserved for IBM internal use.
CONDITIONS	VARCHAR (2500)	An XML document describing the condition for this implicit resource group.
FIELD1	VARCHAR (254)	This column is customizable.
FIELD2	VARCHAR (254)	This column is customizable.
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>	ACRESGRP_ID	Primary Key
I0000010	GRPNAME	Unique Index
I0000446	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

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

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_33	ACRESGRP_ID	ACPOLICY	ACRESGRP_ID	Cascade
F_43	ACRESGRP_ID	ACRESGPDES	ACRESGRP_ID	Cascade
F_44	ACRESGRP_ID	ACRESGPRES	ACRESGRP_ID	Cascade

Related reference
Access control data model