Skip to main content
Skip to main content

user

Overview​

View all user information.

Database​

mysql

Table Information​

Column NameTypeDescription
hostcharacter(255)The host from which the user is allowed to connect.
userchar(32)Username.
node_privchar(1)Whether the user has Node privileges.
admin_privchar(1)Whether the user has Admin privileges.
grant_privchar(1)Whether the user has Grant privileges.
select_privchar(1)Whether the user has Select privileges.
load_privchar(1)Whether the user has Load privileges.
alter_privchar(1)Whether the user has Alter privileges.
create_privchar(1)Whether the user has Create privileges.
drop_privchar(1)Whether the user has Drop privileges.
usage_privchar(1)Whether the user has Usage privileges.
show_view_privchar(1)Whether the user has Show View privileges.
cluster_usage_privchar(1)Whether the user has Cluster usage privileges.
stage_usage_privchar(1)Whether the user has Stage usage privileges.
ssl_typechar(9)Always empty, for MySQL compatibility only.
ssl_ciphervarchar(65533)Always empty, for MySQL compatibility only.
x509_issuervarchar(65533)Always empty, for MySQL compatibility only.
x509_subjectvarchar(65533)Always empty, for MySQL compatibility only.
max_questionsbigintAlways 0, for MySQL compatibility only.
max_updatesbigintAlways 0, for MySQL compatibility only.
max_connectionsbigintAlways 0, for MySQL compatibility only.
max_user_connectionsbigintThe maximum number of allowed connections.
pluginchar(64)Always empty, for MySQL compatibility only.
authentication_stringvarchar(65533)Always empty, for MySQL compatibility only.
password_policy.expiration_secondsvarchar(32)Password expiration time.
password_policy.password_creation_timevarchar(32)Password creation time.
password_policy.history_numvarchar(32)Number of historical passwords.
password_policy.history_passwordsvarchar(65533)Historical passwords.
password_policy.num_failed_loginvarchar(32)Allowed number of consecutive login failures.
password_policy.password_lock_secondsvarchar(32)Password lock time after triggering lock.
password_policy.failed_login_countervarchar(32)Login failure count.
password_policy.lock_timevarchar(32)