ODBC Driver for Microsoft SharePoint

Build 25.0.9434

Groups

Retrieves group details from a SharePoint site, including membership, permissions, and ownership settings. Essential for managing access control and security within SharePoint.

Columns

Name Type References Description
Id [KEY] Int A unique identifier for the SharePoint group. Useful for managing group permissions and retrieving group details.
LoginName String The login name or alias associated with the group. Helps in authentication and managing group-based access control.
Title String The display name of the group. Useful for displaying user-friendly group names in the SharePoint UI.
AllowMembersEditMembership Bool Indicates whether group members have permission to add or remove users from the group. Useful for determining member control policies.
AllowRequestToJoinLeave Bool Indicates whether users can request to join or leave the group. Helps manage open or restricted membership settings.
AutoAcceptRequestToJoinLeave Bool Indicates whether membership requests are automatically approved. Useful for self-service group management.
CanCurrentUserEditMembership Bool Indicates whether the currently logged-in user has permissions to edit the group's membership. Helps determine user-specific permissions.
CanCurrentUserManageGroup Bool Indicates whether the current user has management permissions for the group. Useful for determining administrative access levels.
CanCurrentUserViewMembership Bool Indicates whether the current user can view the group's membership details. Helps enforce security settings and access control.
Description String A brief summary of the group's purpose or function. Useful for providing context about the group’s role in SharePoint.
IsHiddenInUI Bool Indicates whether the group is hidden from the SharePoint user interface. Helps control visibility of system or background groups.
OnlyAllowMembersViewMembership Bool Indicates whether only group members are allowed to view membership details. Useful for maintaining privacy and security settings.
OwnerTitle String The display name of the group's owner. Helps identify the person responsible for managing the group.
RequestToJoinLeaveEmailSetting String The email address where requests to join or leave the group are sent. Useful for managing group membership approvals.
PrincipalType Int Specifies the type of principal associated with the group. Possible values include: None (0), User (1), DistributionList (2), SecurityGroup (4), SharePointGroup (8), All (15). Helps in categorizing different types of groups and users.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434