JDBC Driver for Microsoft SharePoint

Build 22.0.8462

RoleDefinitionBindings

Get Web Role definition binding.

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
ID [KEY] String The ID of the role assigned member.
BasePermissions_High Int64 The base permissions high.
BasePermissions_Low Int64 The base permissions low.
Description String The description.
Hidden Boolean A boolean indicating if it is hidden.
Name String The name.
Order Int The order.
RoleTypeKind Int The role type kind.
PrincipalId String

RoleAssignments.PrincipalId

The Principal Id.
List String

Lists.Title

The internal name of the list to retrieve role assigned member from.
ItemId String List item id for role defintion.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462