Feature
This view displays information about database-level privileges.
Related tables/views
None
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| host | varchar(128) | NO | The name of the host. |
| db | varchar(128) | NO | The name of the database. |
| user | varchar(128) | NO | The username. |
| 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. |
| grant_priv | varchar(1) | NO | Indicates whether the user can grant privileges. |
| 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 TABLE statement. |
| 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. To execute this statement, the user must have the SELECT privilege on the table to be locked. This field is not used now. |
| create_view_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE VIEW statement. |
| 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 execute the ALTER FUNCTION 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. |
| event_priv | varchar(1) | NO | Indicates whether the user can create, delete, or modify events. This field is not used now. |
| trigger_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE TRIGGER or DROP TRIGGER statement. This field is not used now. |