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 | 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 |