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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000001 | GROUPNAME | Unique Index |
SQL030416034824070 | ACACTGRP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_7 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |