Table: okta_user_type - Query Okta User Types using SQL

Okta User Types represent the different categories of users within an Okta organization. They allow for variation in the properties defined for users of different types, thereby enabling more granular control over user access and permissions. User Types are integral to Okta's identity and access management service, providing a flexible and customizable framework for user management.

Table Usage Guide

The okta_user_type table provides insights into User Types within Okta's identity and access management service. As an IT administrator or security analyst, explore user type-specific details through this table, including properties, created and last updated timestamps, and associated metadata. Utilize it to uncover information about user types, such as their specific properties, the time of their creation and last update, and any other relevant details.

Examples

Basic info

Explore the different types of users within your Okta environment. This can help you understand how your system is structured and who has access to what, providing valuable insights for security and access management. Note: default is a reserved word and has to be double-quoted when used as identifier.

select
  name,
  id,
  "default",
  description,
  created,
  created_by
from
  okta_user_type;

select
  name,
  id,
  "default",
  description,
  created,
  created_by
from
  okta_user_type;

Schema for okta_user_type

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		Timestamp when the User Type was created.
created_by	text		The user ID of the creator of this type.
default	boolean		Boolean to indicate if this type is the default.
description	text		A human-readable description of the type.
display_name	text		The display name for the type.
domain	text	=, !=, ~~, ~~, !~~, !~~	The okta domain name.
id	text	=	Unique key for the User Type.
last_updated	timestamp with time zone		Timestamp when the User Type was last updated.
last_updated_by	text		The user ID of the last user to edit this type.
name	text		The name for the type.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- okta

You can pass the configuration to the command with the --config argument:

steampipe_export_okta --config '<your_config>' okta_user_type