ACRESACT

This table captures the relationship between access control resources and actions. Given a resource, you can find out the associated actions from this table.

Column Descriptions:

NameTypeDescription
ACRESCGRY_IDINTEGER NOT NULLThe resource category ID. This is a primary key, as well as a foreign key to the ACRESCGRY table
ACACTION_IDINTEGER NOT NULLThe action ID. It is is a primary key, and a foreign key to the ACACTION table.
OPTCOUNTERSMALLINTThe 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>ACRESCGRY_ID+ACACTION_IDPrimary Key
I0000443ACACTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_38ACACTION_IDACACTIONACACTION_IDCascade
F_39ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade