RoleAssignmentMember
Retrieves details about members assigned to specific roles within SharePoint site permissions. Helps in auditing and managing user access rights.
Table Specific Information
Select
Note: PrincipalId is required to return RoleAssignmentMember.
SELECT * FROM RoleAssignmentMember WHERE PrincipalId = 3 SELECT * FROM RoleAssignmentMember WHERE List = 'TestApp' AND PrincipalId = 3 SELECT * FROM RoleAssignmentMember WHERE PrincipalId = 5 AND list = 'MyTestList' AND ItemId = '3'
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | A unique numeric identifier for the role-assigned member. Useful for tracking specific role assignments. | |
| Updated | Datetime | The date and time when the role assignment was last modified. Helps track changes in permissions and access control. | |
| IsHiddenInUI | Boolean | Indicates whether the assigned role member is hidden from the user interface. Useful for managing background roles that should not be visible. | |
| LoginName | String | The login name of the user or group assigned to the role. Useful for authentication and permission management. | |
| Title | String | The display title of the role-assigned member. Helps in easily identifying assigned users or groups. | |
| PrincipalType | Int | Specifies the type of principal assigned to the role. Possible values: None (0), User (1), DistributionList (2), SecurityGroup (4), SharePointGroup (8), All (15). Helps classify different types of role members. | |
| AllowMembersEditMembership | Boolean | Indicates whether members of the role are allowed to modify group membership. Useful for self-managed roles. | |
| AllowRequestToJoinLeave | Boolean | Indicates whether users can request to join or leave the assigned role. Helps control role accessibility. | |
| AutoAcceptRequestToJoinLeave | Boolean | Indicates whether requests to join or leave the role are automatically approved. Useful for open-access roles. | |
| Description | String | A short description of the role-assigned member. Helps provide additional context on role responsibilities. | |
| OnlyAllowMembersViewMembership | Boolean | Indicates whether only members of the role are allowed to view its membership details. Helps enforce privacy settings. | |
| OwnerTitle | String | The display name of the owner of the assigned role. Useful for identifying role managers or administrators. | |
| RequestToJoinLeaveEmailSetting | String | The email address where membership requests for the role are sent. Useful for managing access requests. | |
| List | String |
Lists.Title | The display name of the SharePoint list from which the role assignment information is retrieved. Helps identify the context of the role assignment. |
| ItemId | Int | The unique identifier of the list item associated with the role assignment. Helps link role assignments to specific items. | |
| PrincipalId | Int |
RoleAssignments.PrincipalId | The unique identifier of the principal (user or group) assigned to the role. Useful for managing security and access control. |