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:

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.


NameColumn NamesType
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

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType