Feature
This view displays the information about user-level privileges on virtual tables.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| host | varchar(128) | NO | The name of the host. |
| user | varchar(128) | NO | The username. |
| password | varchar(128) | NO | The user password. |
| 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. This field is not used now. |
| shutdown_priv | varchar(1) | NO | Indicates whether the user can run the shutdown command. This field is not used now. |
| 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 privileges. This field is not used now. |
| grant_priv | varchar(1) | NO | Indicates whether the user can execute the GRANT statement. |
| reference_priv | varchar(1) | NO | This field is not used now. |
| 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 the SHOW 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. This field is not used now. |
| lock_tables_priv | varchar(1) | NO | Indicates whether the user can execute the LOCK TABLES statement. This field is not used now. |
| execute_priv | varchar(1) | NO | Indicates whether the user can execute stored procedures. This field is not used now. |
| repl_slave_priv | varchar(1) | NO | This field is not used now. |
| repl_client_priv | varchar(1) | NO | This field is not used now. |
| 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. This field is not used now. |
| alter_routine_priv | varchar(1) | NO | Indicates whether the user can modify stored procedures. This field is not used now. |
| 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. This field is not used now. |
| trigger_priv | varchar(1) | NO | Indicates whether the user has the privilege to execute triggers. This field is not used now. |
| create_tablespace_priv | varchar(1) | NO | Indicates whether the user can create tablespaces. This field is not used now. |
| ssl_type | varchar(10) | NO | This field is not used now. |
| ssl_cipher | varchar(1024) | NO | This field is not used now. |
| x509_issuer | varchar(1024) | NO | This field is not used now. |
| x509_subject | varchar(1024) | NO | This field is not used now. |
| max_questions | bigint(20) | NO | The maximum number of queries that a user can perform per hour. This field has not been used. |
| max_updates | bigint(20) | NO | The maximum number of updates that a user can perform per hour. This field is not used now. |
| max_connections | bigint(20) | NO | The maximum number of connections that a user can receive per hour. This field is not used now. |
| max_user_connections | bigint(20) | NO | The maximum number of simultaneous request connections. This field is not used now. |
| plugin | varchar(1024) | NO | This field is not used now. |
| authentication_string | varchar(1024) | NO | This field is not used now. |
| password_expired | varchar(1) | NO | Indicates whether the user password has expired. This field is not used now. |
| account_locked | varchar(1) | NO | Indicates whether the user has been locked. |