Bindings for a resource set.

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 add-in uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• RoleId supports the '=' operator
• ResourceSetId supports the '=' operator

All other filters are processed client-side within the add-in.

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

SELECT * FROM ResourceSetBindings WHERE RoleId = 'cr0kvigwcy053uO2i5d7' AND ResourceSetId = 'iamkx898lmJTqCh2D5d7'

Insert

At minimum the RoleId, ResourceSetId, and Members are required to insert into this table.

A sample Insert is given below.

INSERT INTO ResourceSetBindings (RoleId, ResourceSetId, Members) VALUES ('cr0kvdjoe2VOEEYuP5d7', 'iamkx898lmJTqCh2D5d7', '\"https://dev-60029214.okta.com/api/v1/groups/00gkx3cp6cONN7mbo5d7\"')

Update

Updates are not supported for this table.

Delete

A sample Delete is given below.

DELETE FROM ResourceSetBindings WHERE RoleId = 'cr0kvdjoe2VOEEYuP5d7' AND ResourceSetId = 'iamkx898lmJTqCh2D5d7'

Columns

Name	Type	ReadOnly	Description
RoleId [KEY]	String	False	Role Id
ResourceSetId [KEY]	String	False	Resource Set Id

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
Members	String	URLs to user and/or group instances assigned to the role.