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 Descriptions:

Name	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 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ACPOLICY_ID	Primary Key
I0000006	POLICYNAME+MEMBER_ID	Unique Index
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

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_29	ACRELGRP_ID	ACRELGRP	ACRELGRP_ID	Cascade
F_30	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_31	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade
F_32	ACACTGRP_ID	ACACTGRP	ACACTGRP_ID	Cascade
F_33	ACRESGRP_ID	ACRESGRP	ACRESGRP_ID	Cascade
F_34	ACRELATION_ID	ACRELATION	ACRELATION_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1010	ACPOLICY_ID	ACPOLGPPOL	ACPOLICY_ID	Cascade
F_26	ACPOLICY_ID	ACORGPOL	ACPOLICY_ID	Cascade
F_27	ACPOLICY_ID	ACPOLDESC	ACPOLICY_ID	Cascade