Policies.

View Specific Information

Required Scopes

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

Select

The driver 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 driver.

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