This table defines all commands and views that require access control and categorize them into different groups. This table is deprecated and is provided for backward compatibility only.
Column Name | Column Type | Column Description |
---|---|---|
ACCCMDGRP_ID | INTEGER NOT NULL |
Unique table index. |
ACCCMDTYPE_ID | CHARACTER (32) NOT NULL |
The valid types are defined in ACCCMDTYPE table. Only two types are defined: CONTROLLER and VIEW. CONTROLLER indicates that this entry is for a controller command. VIEW indicates that this entry is for a view. |
INTERFACENAME | VARCHAR (254) NULL |
Interface name for the command. |
MBRGRP_ID | BIGINT NOT NULL |
This refers to a group defined in the MBRGRP table. |
VIEWNAME | VARCHAR (254) NULL |
Name of the view that requires access control. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000004 | MBRGRP_ID, INTERFACENAME, VIEWNAME, ACCCMDTYPE_ID | Unique Index |
SQL030416034825330 | ACCCMDGRP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_11 | ACCCMDTYPE_ID | ACCCMDTYPE | ACCCMDTYPE_ID | Cascade |
F_12 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_14 | ACCCMDGRP_ID | ACCCUSTEXC | ACCCMDGRP_ID | Cascade |