Permissions
The permissions for a site or list. Note: If ItemId is empty, set the ObjectType to List or Web (an ObjectName must be specified when the ObjectType is List). If not, you must specify the ObjectName along with the ItemID.
Columns
| Name | Type | Description |
| MemberID [KEY] | String | A unique identifier for the permission entry. Used to reference and manage specific user or group permissions. |
| Mask | Long | A 32-bit integer in 0x00000000 format representing Microsoft.SharePoint.SPRights values. Defines the permission level; multiple values can be combined using the pipe symbol ('|') in C# or 'Or' in Visual Basic. |
| MemberIsUser | Bool | Indicates whether the permission applies to an individual user. Helps differentiate between user and group permissions. |
| MemberGlobal | Bool | Indicates whether the permission applies to a group. Useful for managing role-based access control. |
| RoleName | String | The name of the site group, cross-site group, or individual user (formatted as DOMAIN\\User_Alias) to whom the permission applies. |
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 |
| ObjectName | String | The name of the SharePoint list or site where the permission is applied. Helps identify the scope of the permission. |
| ObjectType | String | Specifies whether the permission applies to a 'List' or 'Web'. Useful for managing permissions at different levels. |
| ItemID | String | The unique identifier of the item associated with the permission. Helps track specific item-level permissions. |