ACRESGRP

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:

NameTypeDescription
ACRESGRP_IDINTEGER NOT NULLThe resource group ID.
MEMBER_IDBIGINT NOT NULLThe foreign key to the MEMBER table for the owner of this resource group. All resource groups should be owned by the root organization.
GRPNAMEVARCHAR (254) NOT NULLThe name of the resource group.
DESCRIPTIONVARCHAR (254)Reserved for HCL internal use.
CONDITIONSVARCHAR (2500)An XML document describing the condition for this implicit resource group.
FIELD1VARCHAR (254)This column is customizable.
FIELD2VARCHAR (254)This column is customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACRESGRP_IDPrimary Key
I0000010GRPNAMEUnique Index
I0000446MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_46MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_33ACRESGRP_IDACPOLICYACRESGRP_IDCascade
F_43ACRESGRP_IDACRESGPDESACRESGRP_IDCascade
F_44ACRESGRP_IDACRESGPRESACRESGRP_IDCascade