Table: openstack_user

A user is an individual API consumer who can authenticate and access cloud resources. A user is part of only one domain and the username must be unique to the domain.

Examples

Basic user info

select
  name,
  description,
  email,
  enabled,
  lock_password,
  domain_id,
  password_expires_at,
  default_project_id
from
  openstack_user;

User by ID

select
  name,
  description,
  email,
  enabled,
  lock_password,
  domain_id,
  password_expires_at,
  default_project_id
from
  openstack_user
where
  id = 'e021d695cc604acdb8866686b51f6321';

All disabled users

select
  name,
  description,
  email,
  enabled,
  lock_password,
  domain_id,
  password_expires_at,
  default_project_id
from
  openstack_user
where
  enabled = false;

All users with no password expiry date

select
  name,
  description,
  email,
  enabled,
  lock_password,
  domain_id,
  password_expires_at,
  default_project_id
from
  openstack_user
where
  password_expires_at is null;

Schema for openstack_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
default_project_id	text		DefaultProjectID is the ID of the default project of the user.
description	text		Description is the description of the user.
domain_id	text		DomainID is the domain ID the user belongs to.
email	text		Email is the email configured for the user.
enabled	boolean		Enabled is whether or not the user is enabled.
id	text	=	ID is the unique ID of the user.
lock_password	text		Disables the ability for a user to change its password through self-service APIs if set to true.
name	text		Name is the name of the user.
password_expires_at	timestamp with time zone		PasswordExpiresAt is the timestamp when the user's password expires.