This table associates access control resource groups with resource categories (or the classes of resources). You can use this table to group various resources together based on their class names.
Column Description(s):
Column Name | Column Type | Description |
ACRESGRP_ID |
INTEGER NOT NULL |
The resource group ID. It is a foreign key to the ACRESGRP_ID column in the ACRESGRP table. |
ACRESCGRY_ID |
INTEGER NOT NULL |
The resource category ID. It is a foreign key to the ACRESCGRY table. |
FIELD1 |
VARCHAR(128) |
This column is customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031155330 |
ACRESGRP_ID+ACRESCGRY_ID |
Primary Key |
I0000445 |
ACRESCGRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_45 |
ACRESCGRY_ID |
ACRESCGRY |
ACRESCGRY_ID |
Cascade |
F_44 |
ACRESGRP_ID |
ACRESGRP |
ACRESGRP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.