Excel Add-In for Microsoft SharePoint

Build 24.0.8963

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 = 'KatsunariMatsumoto' 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 internal 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963