Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACORGPOL

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
ACPOLICY_ID INTEGER NOT NULL The ID of the template policy. It is a foreign key to the ACPOLICY table.
MEMBER_ID BIGINT NOT NULL The ID of the organizational entity that does not want the template policy applied to it. It is a foreign key to the MEMBER table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030252130 ACPOLICY_ID+MEMBER_ID Primary Key
I0000436 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_26 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade
F_25 MEMBER_ID MEMBER MEMBER_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search