Purpose
The mysql.user view provides information about user-level privileges. It is a virtual table.
Note
This view is introduced since OceanBase Database V3.2.1.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| host | varchar(128) | NO | The name of the host. |
| user | varchar(128) | NO | The username. |
| password | varchar(128) | NO | The password of the user. |
| select_priv | varchar(1) | NO | Indicates whether the user can execute the SELECT statement. |
| insert_priv | varchar(1) | NO | Indicates whether the user can execute the INSERT statement. |
| update_priv | varchar(1) | NO | Indicates whether the user can execute the UPDATE statement. |
| delete_priv | varchar(1) | NO | Indicates whether the user can execute the DELETE statement. |
| create_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE statement. |
| drop_priv | varchar(1) | NO | Indicates whether the user can execute the DROP statement. |
| reload_priv | varchar(1) | NO | Indicates whether the user can execute the FLUSH statement. At present, this column is not used. |
| shutdown_priv | varchar(1) | NO | Indicates whether the user can run the shutdown command. At present, this column is not used. |
| process_priv | varchar(1) | NO | Indicates whether the user can query information about active threads. |
| file_priv | varchar(1) | NO | Indicates whether the user has the file read and write privilege. At present, this column is not used. |
| grant_priv | varchar(1) | NO | Indicates whether the user can execute the GRANT statement. |
| reference_priv | varchar(1) | NO | This column is not used. |
| index_priv | varchar(1) | NO | Indicates whether the user can create indexes. |
| alter_priv | varchar(1) | NO | Indicates whether the user can execute the ALTER statement. |
| show_db_priv | varchar(1) | NO | Indicates whether the user can execute theSHOW DATABASE statement. |
| super_priv | varchar(1) | NO | Indicates whether the user can execute superuser statements. |
| create_tmp_table_priv | varchar(1) | NO | Indicates whether the user can create temporary tables. At present, this column is not used. |
| lock_tables_priv | varchar(1) | NO | Indicates whether the user can execute the LOCK TABLES statement. At present, this column is not used. |
| execute_priv | varchar(1) | NO | Indicates whether the user can execute stored procedures. At present, this column is not used. |
| repl_slave_priv | varchar(1) | NO | This column is not used. |
| repl_client_priv | varchar(1) | NO | This column is not used. |
| create_view_priv | varchar(1) | NO | Indicates whether the user can create views. |
| show_view_priv | varchar(1) | NO | Indicates whether the user can execute the SHOW CREATE VIEW statement. |
| create_routine_priv | varchar(1) | NO | Indicates whether the user can create stored procedures. At present, this column is not used. |
| alter_routine_priv | varchar(1) | NO | Indicates whether the user can modify stored procedures. At present, this column is not used. |
| create_user_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE USER statement. |
| event_priv | varchar(1) | NO | Indicates whether the user can create, modify, and delete events. At present, this column is not used. |
| trigger_priv | varchar(1) | NO | Indicates whether the user has the privilege to execute triggers. At present, this column is not used. |
| create_tablespace_priv | varchar(1) | NO | Indicates whether the user can create tablespaces. At present, this column is not used. |
| ssl_type | varchar(10) | NO | At present, this column is not used. |
| ssl_cipher | varchar(1024) | NO | At present, this column is not used. |
| x509_issuer | varchar(1024) | NO | At present, this column is not used. |
| x509_subject | varchar(1024) | NO | At present, this column is not used. |
| max_questions | bigint(20) | NO | The maximum number of queries that a user can perform per hour. This column is not used. |
| max_updates | bigint(20) | NO | The maximum number of updates that a user can perform per hour. At present, this column is not used. |
| max_connections | bigint(20) | NO | The maximum number of connections that a user can receive per hour. At present, this column is not used. |
| max_user_connections | bigint(20) | NO | The maximum number of simultaneous request connections. At present, this column is not used. |
| plugin | varchar(1024) | NO | At present, this column is not used. |
| authentication_string | varchar(1024) | NO | At present, this column is not used. |
| password_expired | varchar(1) | NO | Indicates whether the user password has expired. At present, this column is not used. |
| account_locked | varchar(1) | NO | Indicates whether the user has been locked. |