Users

You can use the information_schema.users view to return information about users. You can use a SELECT query to return information about each user, as shown in the example below. To view information about users, you must have user privilege or ownership of the user object.

SELECT
  *
FROM
  information_schema.users;

For more information, see Managing users.

Columns in information_schema.users

The login_name and service_account_name columns are not supported in Firebolt OSS.

Each row has the following columns with information about each user.

Column Name	Data Type	Description
user_name	TEXT	The name of the user.
login_name	TEXT	The name of the login linked to the user. Empty if the login is linked to a service account.
service_account_name	TEXT	The name of the service account linked to the user. Empty if the login is linked to a service account.
default_database	TEXT	The default database set for the user.
default_schema	TEXT	The default schema set for the user.
default_engine	TEXT	The default engine set for the user.
created	TIMESTAMPTZ	Time the user was created.
user_owner	TEXT	The name of the user who created the user.
last_altered	TIMESTAMPTZ	Time the user was last altered.
last_altered_by	TEXT	The name of the last user to edit the user.

Transitive applicable roles

Views

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.users

​Columns in information_schema.users

Columns in information_schema.users