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

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

What is Firebolt?

Overview

Self-Managed

Performance and Observability

Guides

SQL reference

General reference

API reference

Legal

Columns in information_schema.users

​Columns in information_schema.users

Columns in information_schema.users