Table: openstack_application_credential

An application credential consists of a credential ID and a secret string. It is used by applications to interact with OpenStack and deployed resources.

Examples

Basic application credential info

select
  name,
  description,
  unrestricted,
  project_id,
  roles,
  expires_at
from
  openstack_application_credential;

Application credential by ID and UserID

select
  name,
  description,
  unrestricted,
  project_id,
  roles,
  expires_at
from
  openstack_application_credential
where
  id = 'e9b1ae13d4254d0c9fb9387f64e4a953'
  and user_id = '6c85c7ff83f24ac0a64f56db18782ecb';

All application credentials allowing unrestricted access

select
  id,
  name,
  description,
  project_id,
  roles,
  expires_at
from
  openstack_application_credential
where
  unrestricted = true;

All expired application credentials

select
  id,
  name,
  description,
  project_id,
  roles
from
  openstack_application_credential
where
  expires_at < cast(now() as date);

Schema for openstack_application_credential

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
access_rules	jsonb		A list of access rules objects.
description	text		A description of the application credential’s purpose.
expires_at	timestamp with time zone		The expiration time of the application credential, if one was specified.
id	text	=	The ID of the application credential.
links	jsonb		Links contains referencing links to the application credential.
name	text		The name of the application credential.
project_id	text		The ID of the project the application credential was created for and that authentication requests using this application credential will be scoped to.
roles	jsonb		A list of one or more roles that this application credential has associated with its project. A token using this application credential will have these same roles.
secret	text		Description is the description of the Domain.
unrestricted	boolean		A flag indicating whether the application credential may be used for creation or destruction of other application credentials or trusts.
user_id	text	=	The ID of the user the application credential belongs to.