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.
For more information, see Managing logins.
Each row has the following columns with information about each login.
|Name of the login (email address).
|First name of the user linked to the login.
|Last name of the user linked to the login.
|Name of the organization.
|Name of the network policy associated with the login.
|Specifies if the login has multi-factor authentication enabled.
|Specifies if the login was provisioned with an identity provider defined in the organization’s SSO configuration.
|Specifies if log in with password is enabled.
|Specifies if the login is an organization admin.
|Time the login was created.
|Name of the login who created the login. If the login was created by a service account, the service account name appears instead.
|Time the login was last altered.
|Name of the login who edited the login. If the login was edited by a service account, the service account name appears instead.