JDBC Driver for Microsoft SharePoint

Build 22.0.8462

Roles

Create, update, delete, and query Roles from SharePoint.

Table Specific Information

Select

To use the UserName pseudo column, you must set the value to the LoginName of the user. You can obtain the LoginName by querying the Users table.

Insert

To insert a Role, at least the Name is required:

INSERT INTO Roles (Name) VALUES ('My Role')

Columns

Name Type ReadOnly Description
Name# [KEY] String False

The name of the role.

Description# String False

A description of the role.

Permissions# Long False

A long representing the permissions for the role.

RoleType String True

The type of role.

IsHidden Boolean True

A boolean indicating if the role is hidden.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
UserName String

The login name of the user to return roles for. Specify this value on a SELECT statement to return only roles assigned to the specified user.

GroupName String

The name of the group to return roles for. Specify this value on a SELECT statement to return only roles assigned to the specified group.

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