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. |