ODBC Driver for Microsoft SharePoint

Build 24.0.9060

RoleAssignments

Acquires Web RoleAssignments.

Table Specific Information

Select


SELECT * FROM RoleAssignments WHERE List = 'TestApp'
SELECT * FROM RoleAssignments WHERE PrincipalId = 5 AND list = 'KatsunariMatsumoto' AND ItemId = '3'

Columns

Name Type References Description
ID [KEY] String The Id of the role assigned.
PrincipalId Int The Principal ID for role assigned.
Updated Datetime The updated date for role assigned.
List String

Lists.Title

The internal name of the list to retrieve role assigned from.
ItemId Int List item id for role assignments.

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