ACRELGRP

This table is a master list of all the access control relationship groups that exist in the system. These relationship groups are between resources that are protected and the users in the system.

Column Descriptions:

NameTypeDescription
ACRELGRP_IDINTEGER NOT NULLThe relationship group ID.
MEMBER_IDBIGINT NOT NULLThis column is a foreign key to the MEMBER table for the owner of this relationship group. All relationship groups should be owned by the root organization.
GRPNAMEVARCHAR (200) NOT NULLThe name of the relationship group.
CONDITIONSVARCHAR (2500)This column contains an XML document describing the condition for this implicit relationship group.
FIELD1VARCHAR (64)This column is customizable.
DESCRIPTIONVARCHAR (254)Reserved for HCL internal use.
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>ACRELGRP_IDPrimary Key
I0000008GRPNAME+MEMBER_IDUnique Index
I0000442MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_37MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_29ACRELGRP_IDACPOLICYACRELGRP_IDCascade
F_54ACRELGRP_IDACRLGPDESCACRELGRP_IDCascade