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 provider 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 provider.

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.