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:

NameTypeDescription
ACACTGRP_IDINTEGER NOT NULLThe action group ID. This is a primary key.
GROUPNAMEVARCHAR (128) NOT NULLThe name of the action group.
MEMBER_IDBIGINT NOT NULLThe foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization.
FIELD1VARCHAR (128)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>ACACTGRP_IDPrimary Key
I0000001GROUPNAMEUnique Index
I0000427MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_7MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_2ACACTGRP_IDACACGPDESCACACTGRP_IDCascade
F_3ACACTGRP_IDACACTACTGPACACTGRP_IDCascade
F_32ACACTGRP_IDACPOLICYACACTGRP_IDCascade