Database Table: ACCCMDGRP

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000004 MBRGRP_ID, INTERFACENAME, VIEWNAME, ACCCMDTYPE_ID Unique Index
SQL030416034825330 ACCCMDGRP_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_14 ACCCMDGRP_ID ACCCUSTEXC ACCCMDGRP_ID Cascade