Groups
Allows the creation, modification, deletion, and retrieval of SharePoint security groups. Essential for managing user permissions and access control.
Table Specific Information
Insert
The Name, DefaultLogin, and OwnerLogin columns are required to insert to this table.
To use the UserName pseudo column, you must set the value to the LoginName of the user. You can obtain the LoginName by querying the Users table.
Columns
| Name | Type | ReadOnly | Description |
| Name# [KEY] | String | False |
The name of the group. Helps identify the group within SharePoint. |
| Description# | String | False |
A brief description of the group. Useful for understanding its purpose and membership. |
| OwnerLogin# | String | False |
The login name of the group's owner, formatted as DOMAIN\\username. Helps track group administration responsibilities. |
| OwnerType# | String | False |
Specifies whether the owner is a user or another group. Helps define group management hierarchy. |
| DefaultLogin# | String | False |
The login name of the default user for the group, formatted as DOMAIN\\username. Useful for assigning default permissions. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UserName | String |
The logical name of the user whose group memberships should be retrieved. Specify this value in a SELECT statement to filter results to groups the user belongs to. |