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:
| Name | Type | Description |
| ACPOLICY_ID | INTEGER NOT NULL | The policy ID of this policy record. This is the
primary key. |
| POLICYNAME | VARCHAR (128) NOT NULL | The name of the policy. |
| ACRELGRP_ID | INTEGER | The relationship group ID to which this policy
refers. |
| ACACTGRP_ID | INTEGER NOT NULL | The action group ID. The ID of the action group
to which this policy refers. It is a foreign key to the ACACTGRP
table. |
| ACRESGRP_ID | INTEGER NOT NULL | The resource group ID to which this policy
refers. |
| ACRELATION_ID | INTEGER | The relation ID to which this policy refers. |
| POLICYTYPE | INTEGER | This 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. |
| FIELD1 | VARCHAR (128) | This column is customizable. |
| MBRGRP_ID | BIGINT NOT NULL | The member group ID. It is a foreign key to the
MBRGRP_ID column in the MBRGRP table. |
| MEMBER_ID | BIGINT NOT NULL | The member ID of the policy owner. It is a
foreign key to the MEMBER table. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ACPOLICY_ID | Primary Key |
| 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 |
| I0000440 | ACRELGRP_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 Child Tables:
| Constraint | Columns | Child Table | Child Columns | 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 |