Group Table

Each Group identifies either a named group or an unnamed Access Control List (ACL). Each Group is associated with rows in the Member table.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for Group table

Database Column

Details

GroupID

Type: integer. Key. Generated ID

The ID for the group, automatically generated by SQL Server.

GUID

Type: binary (max 16 bytes). Key

The Globally Unique IDentifier for the group. In the case where this Group represents an Access Control List for a Policy or a PackageAllocation, the GUID is that of this object.

GroupCN

Type: text (max 128 characters). Key. Nullable

The Common Name for the group. In the case where this Group represents an Access Control List for a Policy or a PackageAllocation, the GroupCN is NULL.

GroupOUID

Type: integer. Key

A reference to the Organization to which the group belongs.

GroupType

Type: integer. Nullable

The bitmask of flags defining the type of this Group.

SID

Type: text (max 256 characters). Nullable

The security identifier of this Group.