RoleAssignmentMember
Get Web RoleAssignments member.
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 | The ID of the role assigned member. | |
| Updated | Datetime | The updated date for role assigned member. | |
| IsHiddenInUI | Boolean | A Boolean indicating if the assigned role member is hidden in UI. | |
| LoginName | String | The login name of the role assigned member. | |
| Title | String | The title of the role assigned member. | |
| PrincipalType | Int | The principal type of the role assigned member. None = 0; User = 1; DistributionList = 2; SecurityGroup = 4; SharePointGroup = 8; All principal types = 15. | |
| AllowMembersEditMembership | Boolean | A Boolean indicating whether to allow members edit membership. | |
| AllowRequestToJoinLeave | Boolean | A Boolean indicating whether to allow request to join leave. | |
| AutoAcceptRequestToJoinLeave | Boolean | A Boolean indicating whether to auto accept request to join leave. | |
| Description | String | The description of the role assigned member. | |
| OnlyAllowMembersViewMembership | Boolean | A Boolean indicating whether to only allow members view membership. | |
| OwnerTitle | String | The owner title of the role assigned member. | |
| RequestToJoinLeaveEmailSetting | String | The request to join leave email setting of the role assigned member. | |
| List | String |
Lists.Title | The display name of the list to retrieve role assigned member from. |
| ItemId | Int | List item id for role assignment. | |
| PrincipalId | Int |
RoleAssignments.PrincipalId | The Principal Id. |