This table defines all commands and views that require access control and categorizes them into different groups. This table is deprecated and is provided for backward compatibility only.
Column Description(s):
Column Name | Column Type | Description |
ACCCMDGRP_ID |
INTEGER NOT NULL |
This column is a unique table index. |
MBRGRP_ID |
BIGINT NOT NULL |
This column refers to a group defined in the MBRGRP table. |
ACCCMDTYPE_ID |
CHAR(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) |
The interface name for the command. |
VIEWNAME |
VARCHAR(254) |
The name of the view that requires access control. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000004 |
MBRGRP_ID+INTERFACENAME+VIEWNAME+ACCCMDTYPE_ID |
Unique Index |
SQL050212031152220 |
ACCCMDGRP_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_14 |
ACCCMDGRP_ID |
ACCCUSTEXC |
ACCCMDGRP_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.