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 Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000009 |
RESCLASSNAME |
Unique Index |
SQL050212031155010 |
ACRESCGRY_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.