This table stores all the access control action groups. An action group can contain one or more actions. The association between actions and action groups is captured in the ACACTACTGP table.
Column Description(s):
Column Name | Column Type | Description |
ACACTGRP_ID |
INTEGER NOT NULL |
The action group ID. This is a primary key. |
GROUPNAME |
VARCHAR(128) NOT NULL |
The name of the action group. |
MEMBER_ID |
BIGINT NOT NULL |
The foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization. |
FIELD1 |
VARCHAR(128) |
This column is customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000001 |
GROUPNAME |
Unique Index |
SQL050212031151650 |
ACACTGRP_ID |
Primary Key |
I0000427 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_7 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_2 |
ACACTGRP_ID |
ACACGPDESC |
ACACTGRP_ID |
Cascade |
F_3 |
ACACTGRP_ID |
ACACTACTGP |
ACACTGRP_ID |
Cascade |
F_32 |
ACACTGRP_ID |
ACPOLICY |
ACACTGRP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.