Roles

Allows the creation, modification, deletion, and retrieval of SharePoint roles and permission assignments. Useful for customizing access control.

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 a minimum 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. Helps identify the permission level assigned to users or groups.
Description#	String	False	A brief description of the role. Useful for understanding its purpose and the permissions it grants.
Permissions#	String	False	A numerical value representing the permissions associated with the role. Helps define access control levels.
RoleType	String	True	Specifies the type of role. Useful for differentiating between built-in roles and custom roles.
IsHidden	Boolean	True	Indicates whether the role is hidden from the user interface. Helps manage roles that are system-defined or restricted.

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.