WebSphere Commerce database table: ACRESGRP

This table stores all the access control resource groups in the system. The conditions column stores an XML document containing the constraints and attribute value pairs used for grouping the resources.


Column Description(s):
Column NameColumn TypeDescription
ACRESGRP_ID INTEGER NOT NULL The resource group ID.
MEMBER_ID BIGINT NOT NULL The foreign key to the MEMBER table for the owner of this resource group. All resource groups should be owned by the root organization.
GRPNAME VARCHAR(254) NOT NULL The name of the resource group.
DESCRIPTION VARCHAR(254) Reserved for IBM internal use.
CONDITIONS VARCHAR(2500) An XML document describing the condition for this implicit resource group.
FIELD1 VARCHAR(254) This column is customizable.
FIELD2 VARCHAR(254) This column is customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000010 GRPNAME Unique Index
SQL050212031155490 ACRESGRP_ID Primary Key
I0000446 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_46 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_33 ACRESGRP_ID ACPOLICY ACRESGRP_ID Cascade
F_43 ACRESGRP_ID ACRESGPDES ACRESGRP_ID Cascade
F_44 ACRESGRP_ID ACRESGPRES ACRESGRP_ID Cascade

Feedback