This table stores all the access control policy groups in the system. Each row in this table represents a policy group.
Column Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000306 |
NAME+MEMBER_ID |
Unique Index |
SQL050212031153870 |
ACPOLGRP_ID |
Primary Key |
I0000439 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1005 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1009 |
ACPOLGRP_ID |
ACPLGPDESC |
ACPOLGRP_ID |
Cascade |
F_1012 |
ACPOLGRP_ID |
ACPLGPSUBS |
ACPOLGRP_ID |
Cascade |
F_1011 |
ACPOLGRP_ID |
ACPOLGPPOL |
ACPOLGRP_ID |
Cascade |
F_1006 |
PARENT_ID |
ACPOLSUBGP |
ACPOLGRP_ID |
Cascade |
F_1007 |
CHILD_ID |
ACPOLSUBGP |
ACPOLGRP_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.