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 Descriptions:
| Name | 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 NOT NULL DEFAULT 0 | 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> | ACRESGRP_ID+ACRESCGRY_ID | Primary Key |
| I0000445 | ACRESCGRY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_44 | ACRESGRP_ID | ACRESGRP | ACRESGRP_ID | Cascade |
| F_45 | ACRESCGRY_ID | ACRESCGRY | ACRESCGRY_ID | Cascade |