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 Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000008 |
GRPNAME+MEMBER_ID |
Unique Index |
SQL050212031154550 |
ACRELGRP_ID |
Primary Key |
I0000442 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_37 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_29 |
ACRELGRP_ID |
ACPOLICY |
ACRELGRP_ID |
Cascade |
F_54 |
ACRELGRP_ID |
ACRLGPDESC |
ACRELGRP_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.