> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Use this reference to learn about the metadata available for Firebolt logins using the information schema.

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  information_schema.logins;
```

For more information, see [Managing logins](/guides/managing-your-organization/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. |