Information schema for 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.

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.
account_name TEXT The name of the account.
organization_name TEXT The name of the organization.
default_database TEXT The default database 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.