Available authenticators.

Table Specific Information

Required Scopes

To query this table, Scope must include okta.authenticators.read. To edit this table, it must include okta.authenticators.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 Authenticators WHERE Id = 'aut1nd8PQhGcQtSxB0g4'

Insert

At minimum the Key is required to insert into this table. Note that Okta's API only accepts certain predefined values for the Key. If Key is set to 'custom_app', AgreeToTerms must be set to true.

A sample Insert is given below.

INSERT INTO Authenticators (Key, Name, ProviderType, ProviderConfig) VALUES ('duo', 'Duo Security', 'DUO', '{"integrationKey": "testIntegrationKey", "secretKey": "testSecretKey", "host": "https://api-xxxxxxxx.duosecurity.com"}')

Update

A sample Update is given below.

UPDATE Authenticators SET Name = 'NewAuth' WHERE Id = 'autip3aixglrcTn8L5d7'

Delete

Deletes are not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the authenticator
Type	String	False	Type of authenticator
Key	String	False	Human-readable string identifying the authenticator
Status	String	False	Status of the authenticator
Name	String	False	Display name of the authenticator
Created	Datetime	True	When the item was created
LastUpdated	Datetime	True	When the item was last updated
ProviderType	String	False	Provider type
ProviderConfig	String	False	Provider configuration
AgreeToTerms	Boolean	False	Whether the admin accepts the terms to create a new authenticator
Settings	String	False	Authenticator settings