Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACPOLICY
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 policy ID of this policy record. This is the primary key. POLICYNAME VARCHAR(128) NOT NULL The name of the policy. ACRELGRP_ID INTEGER The relationship group ID to which this this policy refers. ACACTGRP_ID INTEGER NOT NULL The action group ID. The ID of the action group to which this policy refers. It is a foreign key to the ACACTGRP table. ACRESGRP_ID INTEGER NOT NULL The resource group ID to which this policy refers. ACRELATION_ID INTEGER The relation ID to which this policy refers. POLICYTYPE INTEGER This column is used to distinguish between the different policy types. 2 is a groupable standard policy. 3 is a groupable template policy. Policies of type 2 and 3 must belong to a policy group in order to be applied to an organization. Policy types 0, 1 and null, are deprecated. Policy type 1 indicates that it is a template policy. If it is 0 or null, it is a standard policy. Policies of type 0, 1 and null are applied based on their ownership: they apply to resources owned by the policy owner. FIELD1 VARCHAR(128) This column is customizable. MBRGRP_ID BIGINT NOT NULL The member group ID. It is a foreign key to the MBRGRP_ID column in the MBRGRP table. MEMBER_ID BIGINT NOT NULL The member ID of the policy owner. It is a foreign key to the MEMBER table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000006 POLICYNAME+MEMBER_ID Unique Index SQL100520030253020 ACPOLICY_ID Primary Key I0000316 ACRESGRP_ID Non-Unique Index I0000317 MEMBER_ID Non-Unique Index I0000318 ACRELATION_ID Non-Unique Index I0000319 MBRGRP_ID Non-Unique Index I0000320 ACACTGRP_ID Non-Unique Index I0000440 ACRELGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_32 ACACTGRP_ID ACACTGRP ACACTGRP_ID Cascade F_34 ACRELATION_ID ACRELATION ACRELATION_ID Cascade F_29 ACRELGRP_ID ACRELGRP ACRELGRP_ID Cascade F_33 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade F_31 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_30 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_26 ACPOLICY_ID ACORGPOL ACPOLICY_ID Cascade F_27 ACPOLICY_ID ACPOLDESC ACPOLICY_ID Cascade F_1010 ACPOLICY_ID ACPOLGPPOL ACPOLICY_ID Cascade
Related reference
_vcc_freeselect_bottom_