RoleAssignments
Retrieves role assignments configured on a SharePoint site, including users and groups with access. Useful for reviewing and managing SharePoint security policies.
Table Specific Information
Select
SELECT * FROM RoleAssignments WHERE List = 'TestApp' SELECT * FROM RoleAssignments WHERE PrincipalId = 5 AND list = 'MyListName' AND ItemId = '3'
Columns
| Name | Type | References | Description |
| ID [KEY] | String | A unique identifier for the role assignment. Useful for tracking and managing permissions in SharePoint. | |
| PrincipalId | Int | The unique identifier of the principal (user or group) assigned to the role. Helps manage access control and security settings. | |
| Updated | Datetime | The date and time when the role assignment was last modified. Useful for auditing permission changes. | |
| List | String |
Lists.Title | The display name of the SharePoint list containing the role assignment. Helps identify where the role is applied. |
| ItemId | Int | The unique identifier of the list item associated with the role assignment. Useful for linking role assignments to specific records. |