# Information Schema USERS Table

{% hint style="info" %}
This table is available from [MariaDB 11.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.5/what-is-mariadb-115).
{% endhint %}

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `USERS` table contains information about users, [password expiry](https://mariadb.com/docs/server/security/user-account-management/user-password-expiry), and the limits set by [max\_password\_errors](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_password_errors). Unprivileged users can access their own data, which is different to what [mysql.global\_priv](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-global_priv-table) provides.

It contains the following columns:

| Column                     | Description                                                                                                                                                                                                                                                                                                                                                                         |
| -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| USER                       | In the format user\_name\@host\_name.                                                                                                                                                                                                                                                                                                                                               |
| PASSWORD\_ERRORS           | A current accumulated value of consecutive password login failures. If password\_errors is not applicable for the user (see [max\_password\_errors](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_password_errors)), PASSWORD\_ERRORS will be NULL. Only password login attempts with nonempty password are taken into account. |
| PASSWORD\_EXPIRATION\_TIME | A timestamp with the exact point in time calculated from password\_last\_changed and password\_lifetime (i.e. days) stored for the user.                                                                                                                                                                                                                                            |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}