This table stores all the access control resource
groups in the system. The conditions column stores an XML document
containing the constraints and attribute value pairs used for
grouping the resources.
Column Descriptions:
Name | Type | Description |
ACRESGRP_ID | INTEGER NOT NULL | The resource group ID. |
MEMBER_ID | BIGINT NOT NULL | The foreign key to the MEMBER table for the owner
of this resource group. All resource groups should be owned by the
root organization. |
GRPNAME | VARCHAR (254) NOT NULL | The name of the resource group. |
DESCRIPTION | VARCHAR (254) | Reserved for HCL internal use. |
CONDITIONS | VARCHAR (2500) | An XML document describing the condition for this
implicit resource group. |
FIELD1 | VARCHAR (254) | This column is customizable. |
FIELD2 | VARCHAR (254) | This column is customizable. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | 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> | ACRESGRP_ID | Primary Key |
I0000010 | GRPNAME | Unique Index |
I0000446 | MEMBER_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_46 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_33 | ACRESGRP_ID | ACPOLICY | ACRESGRP_ID | Cascade |
F_43 | ACRESGRP_ID | ACRESGPDES | ACRESGRP_ID | Cascade |
F_44 | ACRESGRP_ID | ACRESGPRES | ACRESGRP_ID | Cascade |