Custom roles.

Table Specific Information

Required Scopes

To query this table, Scope must include okta.roles.read. To edit this table, it must include okta.roles.manage.

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '=' operator

All other filters are processed client-side within the driver.

For example, the following query is processed server-side:

SELECT * FROM Roles WHERE Id = 'cr0Yq6IJxGIr0ouum0g3'

Insert

At minimum the Label, Description, and Permissions are required to insert into this table.

A sample Insert is given below.

INSERT INTO Roles (Label, Description, Permissions) VALUES ('MyCustomRole1', 'My role', '\"okta.users.read\", \"okta.groups.read\"')

Update

Only the Label and Description can be updated.

A sample Update is given below.

UPDATE Roles SET Label = 'custrole' WHERE Id = 'cr0kvigwcy053uO2i5d7'

Delete

A sample Delete is given below.

DELETE FROM Roles WHERE Id = 'cr0kvigwcy053uO2i5d7'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the role
Created	Datetime	True	When the item was created
LastUpdated	Datetime	True	When the item was last updated
Label	String	False	Unique label for a role
Description	String	False	Description of a role

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
Permissions	String	Role permissions