ACACTION

This table stores all the access control actions in the system.

Column Descriptions:

Name	Type	Description
ACACTION_ID	INTEGER NOT NULL	The action ID. This is a primary key.
ACTION	VARCHAR (254) NOT NULL	This is the action to which this record refers.
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>	ACACTION_ID	Primary Key
I0000002	ACTION	Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_38	ACACTION_ID	ACRESACT	ACACTION_ID	Cascade
F_4	ACACTION_ID	ACACTACTGP	ACACTION_ID	Cascade
F_6	ACACTION_ID	ACACTDESC	ACACTION_ID	Cascade

Related reference
Access control data model