JDBC Driver for Okta

Build 24.0.9175

AuthorizationServers

Custom authorization servers.

Table Specific Information

Required Scopes

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

Insert

At minimum the Name and Audiences are required to insert into this table.

A sample Insert is given below.

INSERT INTO AuthorizationServers (Name, Audiences) VALUES ('newAuthServer', '\"InsertedServerAudiences\"')

Update

A sample Update is given below.
UPDATE AuthorizationServers SET CredRotationMode = 'MANUAL' WHERE Id = 'ausmah5syfkFZjmsX5d7'

Delete

A sample Delete is given below.
DELETE FROM AuthorizationServers WHERE Id = 'ausmah5syfkFZjmsX5d7'

Columns

Name Type ReadOnly Description
Id [KEY] String True

Id of the server

Name String False

Display name of the server

Description String False

Description of the server

Status String False

Status of the server

Created Datetime True

When the item was created

LastUpdated Datetime True

When the item was last updated

Issuer String False

URL for the custom authorization server

IssuerMode String False

Which URL is specified in the issuer of the tokens that a custom authorization server returns

Audiences String False

The recipients that the tokens are intended for

CredRotationMode String False

User verification setting

CredLastRotated Datetime True

When the item was last updated

CredNextRotation Datetime True

When the item was last updated

CredKid String True

ID of the JSON Web Key used for signing tokens issued by the authorization server

CredUse String False

How the key is used

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175