ACRESGPRES

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:

NameTypeDescription
ACRESGRP_IDINTEGER NOT NULLThe resource group ID. It is a foreign key to the ACRESGRP_ID column in the ACRESGRP table.
ACRESCGRY_IDINTEGER NOT NULLThe resource category ID. It is a foreign key to the ACRESCGRY table.
FIELD1VARCHAR (128)This column is customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACRESGRP_ID+ACRESCGRY_IDPrimary Key
I0000445ACRESCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_44ACRESGRP_IDACRESGRPACRESGRP_IDCascade
F_45ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade