Database Table: ACACTGRP

This table stores all the access control action groups. An action group can contain one or more actions. The association between actions and action groups is captured in the ACACTACTGP table.

Column Name Column Type Column Description
ACACTGRP_ID INTEGER
NOT NULL
Action group ID. This is a Primary Key.
FIELD1 VARCHAR (128)
NULL
Customizable.
GROUPNAME VARCHAR (128)
NOT NULL
Name of the action group.
MEMBER_ID BIGINT
NOT NULL
Foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization.
Indexes:
Index Name Indexed Column Names Index Type
I0000001 GROUPNAME Unique Index
SQL030416034824070 ACACTGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_7 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_2 ACACTGRP_ID ACACGPDESC ACACTGRP_ID Cascade
F_3 ACACTGRP_ID ACACTACTGP ACACTGRP_ID Cascade
F_32 ACACTGRP_ID ACPOLICY ACACTGRP_ID Cascade