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