Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACCCUSTEXC

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 refers to an entry in the ACCCMDGRP table. It should only refer to an entry that corresponds to a customer group, for example, where MBRGRP_ID = -2.
OWNER_ID BIGINT NOT NULL This column defines the member that excludes the corresponding command or view defined in the ACCCMDGRP table from the customer group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030251430 OWNER_ID+ACCCMDGRP_ID Primary Key
I0001234 ACCCMDGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_14 ACCCMDGRP_ID ACCCMDGRP ACCCMDGRP_ID Cascade
F_13 OWNER_ID MEMBER MEMBER_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search