Information schema for logins

You can use the information_schema.logins view to return information about logins.

You can use a SELECT query to return information about each login, as shown in the example below.

SELECT
  *
FROM
  information_schema.logins;

For more information, see Managing logins.

Columns in information_schema.logins

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

Column Name	Data Type	Description
login_name	TEXT	Name of the login (email address).
first_name	TEXT	First name of the user linked to the login.
last_name	TEXT	Last name of the user linked to the login.
organization_name	TEXT	Name of the organization.
network_policy_name	TEXT	Name of the network policy associated with the login.
is_mfa_enabled	BOOLEAN	Specifies if the login has multi-factor authentication enabled.
is_sso_provisioned	BOOLEAN	Specifies if the login was provisioned with an identity provider defined in the organization’s SSO configuration.
is_password_enabled	BOOLEAN	Specifies if log in with password is enabled.
is_organization_admin	BOOLEAN	Specifies if the login is an organization admin.
is_enabled	BOOLEAN	Specifies if the login is allowed to authenticate.
created	TIMESTAMPTZ	Time the login was created.
login_owner	TEXT	Name of the login who created the login. If the login was created by a service account, the service account name appears instead.
last_altered	TIMESTAMPTZ	Time the login was last altered.
last_altered_by	TEXT	Name of the login who edited the login. If the login was edited by a service account, the service account name appears instead.