Purpose
The mysql.db view displays information about database-level privileges.
Note
This view is introduced since OceanBase Database V1.4.
Related tables/views
None
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| host_name | 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 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 TABLE statement. |
| 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. To execute this statement, the user must have the SELECT privilege on the table to be locked. At present, this column is not used. |
| 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 column is not used now. |
| alter_routine_priv | varchar(1) | NO | Indicates whether the user can execute the ALTER FUNCTION statement. This column is not used now. |
| execute_priv | varchar(1) | NO | Indicates whether the user can execute stored procedures. This column is not used now. |
| event_priv | varchar(1) | NO | Indicates whether the user can create, delete, or modify events. This column is not used now. |
| trigger_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE TRIGGER or DROP TRIGGER statement. At present, this column is not used. |