Database Table: ACPOLICY

This table stores all the access control policies in the system. Each policy is a row in the policy table. Every policy refers to an action group, a member group, a resource group and optionally a relationship.

Column Name Column Type Column Description
ACACTGRP_ID INTEGER
NOT NULL
Action group ID. The ID of the action group that this policy refers to. Foreign key to the ACACTGRP table.
ACPOLICY_ID INTEGER
NOT NULL
Policy ID of this policy record. This is the primary key.
ACRELATION_ID INTEGER
NULL
Relation ID that this policy refers to.
ACRELGRP_ID INTEGER
NULL
Relationship group ID that this policy refers to.
ACRESGRP_ID INTEGER
NOT NULL
Resource group ID this policy refers to.
FIELD1 VARCHAR (128)
NULL
Customizable.
MBRGRP_ID BIGINT
NOT NULL
Member group ID. Foreign key to the MBRGRP_ID field table MBRGRP table.
MEMBER_ID BIGINT
NOT NULL
Member ID of the policy owner. Foreign key to the MEMBER table.
POLICYNAME VARCHAR (128)
NOT NULL
Name of the policy.
POLICYTYPE INTEGER
NULL
This field 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.
Indexes:
Index Name Indexed Column Names Index Type
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
SQL030416034829590 ACPOLICY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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