This table stores the relationship between access control resources and attributes. These attributes are used to implicitly group resources. Given a resource, you can find out the supported attributes from this table. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL statements for prefiltering.
Column Description(s):
Column Name | Column Type | Description |
ACATTR_ID |
BIGINT NOT NULL |
The attribute ID. It is a foreign key to the ACATTR_ID column in the ACATTR table. Together with the ACRESCGRY_ID column, it forms a primary key. |
ACRESCGRY_ID |
INTEGER NOT NULL |
The resource category ID. It is a foreign key to the ACRESCGRY_ID column in the ACRESCGRY table. Together with ACATTR_ID column, it forms a primary key. |
ATTRTBLNAME |
VARCHAR(64) NOT NULL |
Metadata about the attributes. This is the table name where this attribute can be found. |
ATTRCOLNAME |
VARCHAR(64) NOT NULL |
Metadata about attributes. This is the column name where this attribute is stored for a resource. |
RESKEYCOLNAME |
VARCHAR(64) NOT NULL |
This is the column that stores the resource key in the table that stores the attribute. |
FIELD1 |
VARCHAR(128) |
This column is customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031154840 |
ACATTR_ID+ACRESCGRY_ID |
Primary Key |
I0000444 |
ACRESCGRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_40 |
ACATTR_ID |
ACATTR |
ACATTR_ID |
Cascade |
F_41 |
ACRESCGRY_ID |
ACRESCGRY |
ACRESCGRY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.