ODBC Driver for Okta

Build 24.0.9062

Policies

Policies.

View Specific Information

Required Scopes

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

Select

The 本製品 uses the Okta API to process WHERE clause conditions built with the following columns and operators.

Note that the LIKE operator is case-sensitive.

  • Id supports the '=' operator
  • Name supports the '=' and 'LIKE (starts with)' operators
  • Type supports the '=' operator

All other filters are processed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM Policies WHERE Id = '00plrilJ7jZ66Gn0X0g3'

SELECT * FROM Policies WHERE Type='PASSWORD' and name like 'Default%'

The Type filter only accepts certain values. Possible values for this filter are "OKTA_SIGN_ON" "PASSWORD" "MFA_ENROLL" "IDP_DISCOVERY" "ACCESS_POLICY" "PROFILE_ENROLLMENT" "POST_AUTH_SESSION" "ENTITY_RISK". Note that the policies ACCESS_POLICY, PROFILE_ENROLLMENT, POST_AUTH_SESSION, and ENTITY_RISK are only available in Okta Identity Engine. Note that POST_AUTH_SESSION and ENTITY_RISK are currently in early access and must be enabled in Okta before they can be queried. For this reason, they are not automatically queried and must be specified in the Type filter in order to be queried.

Note: Due to a limitation of the Okta API that affects queries to the Policies endpoint, we only support full-table queries or filters on individual Types or Ids.

Columns

Name Type Description
Id [KEY] String Id of the policy
Created Datetime When the policy was created
LastUpdated Datetime When the policy was last updated
Name String Name of the policy
Type String Type of policy.
System Boolean If this is a system policy
Description String Description of the policy
Priority Integer Priority of the policy
Status String Status of the policy

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