> ## 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 users using the information schema.

# Users

You can use the `information_schema.users` view to return information about users. You can use a `SELECT` query to return information about each user, as shown in the example below.

To view information about users, you must have [user privilege](/overview/security/rbac/user-permissions#user-permissions) or ownership of the user object.

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

For more information, see [Managing users](/guides/managing-your-organization/managing-users).

## Columns in information\_schema.users

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

| Column Name            | Data Type   | Description                                                                                            |
| :--------------------- | :---------- | :----------------------------------------------------------------------------------------------------- |
| user\_name             | TEXT        | The name of the user.                                                                                  |
| login\_name            | TEXT        | The name of the login linked to the user. Empty if the login is linked to a service account.           |
| service\_account\_name | TEXT        | The name of the service account linked to the user. Empty if the login is linked to a service account. |
| default\_database      | TEXT        | The default database set for the user.                                                                 |
| default\_schema        | TEXT        | The default schema set for the user.                                                                   |
| default\_engine        | TEXT        | The default engine set for the user.                                                                   |
| created                | TIMESTAMPTZ | Time the user was created.                                                                             |
| user\_owner            | TEXT        | The name of the user who created the user.                                                             |
| last\_altered          | TIMESTAMPTZ | Time the user was last altered.                                                                        |
| last\_altered\_by      | TEXT        | The name of the last user to edit the user.                                                            |