RoleDefinitionBindings
Lists role definitions bound to specific security groups or users within a SharePoint site. Helps administrators enforce permission policies.
Table Specific Information
Select
NOTE: PrincipalId is required to return RoleDefinitionBindings.
SELECT * FROM RoleDefinitionBindings WHERE PrincipalId = 3 SELECT * FROM RoleDefinitionBindings WHERE List = 'TestApp' AND PrincipalId = 3 SELECT * FROM RoleDefinitionBindings WHERE PrincipalId = 5 AND list = 'KatsunariMatsumoto' AND ItemId = '3'
Columns
| Name | Type | References | Description |
| PrincipalId [KEY] | Int |
RoleAssignments.PrincipalId | The unique identifier of the principal (user or group) assigned to the role. Helps manage security and access control settings. |
| ID [KEY] | Int | A unique identifier for the role-assigned member. Useful for tracking role assignments in SharePoint. | |
| BasePermissions_High | Long | Represents the high-level base permissions applied to the role. Helps define access rights and security policies. | |
| BasePermissions_Low | Long | Represents the low-level base permissions assigned to the role. Used for managing security settings. | |
| Description | String | A short description of the role definition. Useful for understanding the purpose and scope of the assigned role. | |
| Hidden | Boolean | Indicates whether the role definition is hidden from the user interface. Useful for managing system-level roles. | |
| Name | String | The display name of the role definition. Helps users identify the role and its permissions. | |
| Order | Int | The position of the role definition in the order of assignments. Useful for prioritizing role applications. | |
| RoleTypeKind | Int | Specifies the type of role assigned. Helps classify different role definitions within SharePoint. | |
| 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 definition. Useful for linking role definitions to specific records. |