JDBC Driver for Okta

Build 24.0.9060

UserSubscriptions

Subscriptions available to a user.

View Specific Information

Required Scopes

To query this view, Scope must include okta.users.read.

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.
  • NotificationType supports the '=' operator
  • UserId supports the '=' operator

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

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

SELECT * FROM UserSubscriptions WHERE UserId='00ub0oNGTSWTBKOLGLNR'

Columns

Name Type Description
NotificationType String Type of notification
Status String Status of the subscription
Channels String Array of sources that send notifications to users
UserId String User id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060