Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACACTGRP
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 ACACTGRP_ID INTEGER NOT NULL The action group ID. This is a primary key. GROUPNAME VARCHAR(128) NOT NULL The name of the action group. MEMBER_ID BIGINT NOT NULL The foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization. FIELD1 VARCHAR(128) This column is customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000001 GROUPNAME Unique Index SQL100520030250550 ACACTGRP_ID Primary Key I0000427 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_7 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By 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
Related reference
_vcc_freeselect_bottom_