Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACCCMDGRP
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
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.
Indexes Index Name Indexed Column Names Index Type I0000004 MBRGRP_ID+INTERFACENAME+VIEWNAME+ACCCMDTYPE_ID Unique Index SQL100520030251150 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 _vcc_freeselect_bottom_