user
Overviewβ
View all user information.
Databaseβ
mysql
Table Informationβ
| Column Name | Type | Description |
|---|---|---|
| host | character(255) | The host from which the user is allowed to connect. |
| user | char(32) | Username. |
| node_priv | char(1) | Whether the user has Node privileges. |
| admin_priv | char(1) | Whether the user has Admin privileges. |
| grant_priv | char(1) | Whether the user has Grant privileges. |
| select_priv | char(1) | Whether the user has Select privileges. |
| load_priv | char(1) | Whether the user has Load privileges. |
| alter_priv | char(1) | Whether the user has Alter privileges. |
| create_priv | char(1) | Whether the user has Create privileges. |
| drop_priv | char(1) | Whether the user has Drop privileges. |
| usage_priv | char(1) | Whether the user has Usage privileges. |
| show_view_priv | char(1) | Whether the user has Show View privileges. |
| cluster_usage_priv | char(1) | Whether the user has Cluster usage privileges. |
| stage_usage_priv | char(1) | Whether the user has Stage usage privileges. |
| ssl_type | char(9) | Always empty, for MySQL compatibility only. |
| ssl_cipher | varchar(65533) | Always empty, for MySQL compatibility only. |
| x509_issuer | varchar(65533) | Always empty, for MySQL compatibility only. |
| x509_subject | varchar(65533) | Always empty, for MySQL compatibility only. |
| max_questions | bigint | Always 0, for MySQL compatibility only. |
| max_updates | bigint | Always 0, for MySQL compatibility only. |
| max_connections | bigint | Always 0, for MySQL compatibility only. |
| max_user_connections | bigint | The maximum number of allowed connections. |
| plugin | char(64) | Always empty, for MySQL compatibility only. |
| authentication_string | varchar(65533) | Always empty, for MySQL compatibility only. |
| password_policy.expiration_seconds | varchar(32) | Password expiration time. |
| password_policy.password_creation_time | varchar(32) | Password creation time. |
| password_policy.history_num | varchar(32) | Number of historical passwords. |
| password_policy.history_passwords | varchar(65533) | Historical passwords. |
| password_policy.num_failed_login | varchar(32) | Allowed number of consecutive login failures. |
| password_policy.password_lock_seconds | varchar(32) | Password lock time after triggering lock. |
| password_policy.failed_login_counter | varchar(32) | Login failure count. |
| password_policy.lock_time | varchar(32) |
