ACACTGRP

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
ACACTGRP_ID	INTEGER NOT NULL	The action group ID. This is a primary key.
GROUPNAME	VARCHAR (128) NOT NULL	The name of the action group.
MEMBER_ID	BIGINT NOT NULL	The foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization.
FIELD1	VARCHAR (128)	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>	ACACTGRP_ID	Primary Key
I0000001	GROUPNAME	Unique Index
I0000427	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_7	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_2	ACACTGRP_ID	ACACGPDESC	ACACTGRP_ID	Cascade
F_3	ACACTGRP_ID	ACACTACTGP	ACACTGRP_ID	Cascade
F_32	ACACTGRP_ID	ACPOLICY	ACACTGRP_ID	Cascade

Related reference
Access control data model