This table stores all the access control resource
categories in the system and the metadata information about them.
The metadata includes information about the table and the columns
that store the resources belonging to the resource category.
Column Descriptions:
Name | Type | Description |
ACRESCGRY_ID | INTEGER NOT NULL | The ID assigned to this particular resource
category. This is a primary key. |
RESPRIMARYTABLE | VARCHAR (64) | The name of the table that stores the
resource. |
RESOWNERTABLE | VARCHAR (64) | The name of the table that stores the owner of
the resource. |
RESOWNERCOL | VARCHAR (64) | The name of the column that stores the owner of
this resource. |
RESKEYOWNCOL | VARCHAR (64) | The name of the column that has the resource ID
in the table that stores the owner. This is null if the owner is
stored in the same table as the resource itself. |
FIELD1 | VARCHAR (128) | This column is customizable. |
RESCLASSNAME | VARCHAR (254) NOT NULL | The class name of the bean that represents this
resource. For commands, this is the fully-qualified name of the
interface. |
RESJOINKEY | VARCHAR (64) | The column in the resource table to which the key
from the owner table can be joined. This is null if the owner is
stored in the same table as the resource itself. |
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> | ACRESCGRY_ID | Primary Key |
I0000009 | RESCLASSNAME | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_39 | ACRESCGRY_ID | ACRESACT | ACRESCGRY_ID | Cascade |
F_41 | ACRESCGRY_ID | ACRESATREL | ACRESCGRY_ID | Cascade |
F_45 | ACRESCGRY_ID | ACRESGPRES | ACRESCGRY_ID | Cascade |
F_49 | ACRESCGRY_ID | ACRESMEMRL | ACRESCGRY_ID | Cascade |
F_50 | ACRESCGRY_ID | ACRESPRIM | ACRESCGRY_ID | Cascade |
F_52 | ACRESCGRY_ID | ACRESREL | ACRESCGRY_ID | Cascade |
F_55 | ACRESCGRY_ID | ACRSCGDES | ACRESCGRY_ID | Cascade |