ODBC Driver for Act! CRM

Build 26.0.9770

GroupAccessControl

Query and update the access control level for a group.

Table Specific Information

Select

  • GroupId supports the '=' operator.
The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:
SELECT * FROM GroupAccessControl WHERE GroupId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

SELECT * FROM GroupAccessControl

Update

Any column where ReadOnly=False can be updated. Specify the GroupId when updating a group access control record.

UPDATE GroupAccessControl SET Type = 'Private' WHERE GroupId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

Columns

Name Type ReadOnly Description
GroupId [KEY] String True

The unique identifier for the group.

Type String False

Defines the group's access level.

The allowed values are Public, Private, LimitedAccess.

AccessorsAggregate String False

The users or teams that have been granted limited access to the group.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770