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 Description(s):
Column Name | Column 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 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000006 |
POLICYNAME+MEMBER_ID |
Unique Index |
SQL050212031154000 |
ACPOLICY_ID |
Primary Key |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_32 |
ACACTGRP_ID |
ACACTGRP |
ACACTGRP_ID |
Cascade |
F_34 |
ACRELATION_ID |
ACRELATION |
ACRELATION_ID |
Cascade |
F_29 |
ACRELGRP_ID |
ACRELGRP |
ACRELGRP_ID |
Cascade |
F_33 |
ACRESGRP_ID |
ACRESGRP |
ACRESGRP_ID |
Cascade |
F_31 |
MBRGRP_ID |
MBRGRP |
MBRGRP_ID |
Cascade |
F_30 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_26 |
ACPOLICY_ID |
ACORGPOL |
ACPOLICY_ID |
Cascade |
F_27 |
ACPOLICY_ID |
ACPOLDESC |
ACPOLICY_ID |
Cascade |
F_1010 |
ACPOLICY_ID |
ACPOLGPPOL |
ACPOLICY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.