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	The name of the identity to whom this login belongs.
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.

Accounts

Organization

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.logins

​Columns in information_schema.logins

Columns in information_schema.logins