# USERS

This view contains information about users for a given cluster.

If you (the current user) has the `GRANT` permission, you can see all role-group pairs in this view. Otherwise, you will see only the pairs from groups you are part of.

| Column Name                       | Description                                                                                                                                                                                                                                     |
| --------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `USER`                            | The name of a given user.                                                                                                                                                                                                                       |
| `HOST`                            | The hostname or IP address for a given user.                                                                                                                                                                                                    |
| `TYPE`                            | The type of connection authentication.                                                                                                                                                                                                          |
| `CONNECTIONS`                     | The number of connections a given user has open.                                                                                                                                                                                                |
| `IS_DELETED`                      | Whether a given user had been deleted.                                                                                                                                                                                                          |
| `LAST_UPDATED`                    | The timestamp at which a given user was last updated.                                                                                                                                                                                           |
| `DEFAULT_RESOURCE_POOL`           | The default resource pool for a given user.                                                                                                                                                                                                     |
| `IS_LOCAL`                        | Whether a given user is local to the node on which USERS table is being accessed or if it’s a distributed user.                                                                                                                                 |
| `CREATED`                         | The timestamp at which a given user was created.                                                                                                                                                                                                |
| `PASSWORD_EXPIRATION`             | If the`password_expiration_seconds`engine variable is not enabled, this column will be NULL. If the`password_expiration_seconds`engine variable is enabled, the column will display the number of seconds remaining for the password to expire. |
| `PASSWORD_UPDATED`                | The timestamp a given user’s password was last updated.                                                                                                                                                                                         |
| `EFFECTIVE_FAILED_LOGIN_ATTEMPTS` | The number of failed login attempts for a given user.                                                                                                                                                                                           |
| `EFFECTIVE_PASSWORD_LOCK_TIME`    | The amount of time, in milliseconds, a given user’s account has been locked due to failed login attempts.                                                                                                                                       |
| `ACCOUNT_STATUS`                  | Whether a given user account is`LOCKED`due to failed login attempts exceeding the set limit, or if the account is`OPEN`.`N/A`means that a policy has not been set for exceeding login attempts.                                                 |
| `ATTRIBUTE`                       | An optional user field. A JSON object set by including`ATTRIBUTE`as part of \``CREATE USER`or`ALTER USER`.                                                                                                                                      |
| `COMMENT`                         | An optional user comment text string for the user. A comment is set by including`COMMENT`as part of`CREATE USER`or`ALTER USER`.                                                                                                                 |

***

Modified at: April 12, 2023

Source: [/db/v9.1/reference/information-schema-reference/resource-and-user-management/users/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/users/)

(An index of the documentation is available at /llms.txt)