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.
OPTCOUNTERSMALLINTThe 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