ACRELGRP

This table is a master list of all the access control relationship groups that exist in the system. These relationship groups are between resources that are protected and the users in the system.

Column Descriptions:

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

Constrained By Parent Tables:

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

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_29	ACRELGRP_ID	ACPOLICY	ACRELGRP_ID	Cascade
F_54	ACRELGRP_ID	ACRLGPDESC	ACRELGRP_ID	Cascade

Related reference
Access control data model