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:

NameTypeDescription
ACPOLICY_IDINTEGER NOT NULLThe policy ID of this policy record. This is the primary key.
POLICYNAMEVARCHAR (128) NOT NULLThe name of the policy.
ACRELGRP_IDINTEGERThe relationship group ID to which this policy refers.
ACACTGRP_IDINTEGER NOT NULLThe action group ID. The ID of the action group to which this policy refers. It is a foreign key to the ACACTGRP table.
ACRESGRP_IDINTEGER NOT NULLThe resource group ID to which this policy refers.
ACRELATION_IDINTEGERThe relation ID to which this policy refers.
POLICYTYPEINTEGERThis 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.
FIELD1VARCHAR (128)This column is customizable.
MBRGRP_IDBIGINT NOT NULLThe member group ID. It is a foreign key to the MBRGRP_ID column in the MBRGRP table.
MEMBER_IDBIGINT NOT NULLThe member ID of the policy owner. It is a foreign key to the MEMBER table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACPOLICY_IDPrimary Key
I0000006POLICYNAME+MEMBER_IDUnique Index
I0000316ACRESGRP_IDNon-Unique Index
I0000317MEMBER_IDNon-Unique Index
I0000318ACRELATION_IDNon-Unique Index
I0000319MBRGRP_IDNon-Unique Index
I0000320ACACTGRP_IDNon-Unique Index
I0000440ACRELGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_29ACRELGRP_IDACRELGRPACRELGRP_IDCascade
F_30MEMBER_IDMEMBERMEMBER_IDCascade
F_31MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_32ACACTGRP_IDACACTGRPACACTGRP_IDCascade
F_33ACRESGRP_IDACRESGRPACRESGRP_IDCascade
F_34ACRELATION_IDACRELATIONACRELATION_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1010ACPOLICY_IDACPOLGPPOLACPOLICY_IDCascade
F_26ACPOLICY_IDACORGPOLACPOLICY_IDCascade
F_27ACPOLICY_IDACPOLDESCACPOLICY_IDCascade