Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays information about database-level privileges.
Columns
| Column | 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 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. |
Sample query
Query the database-level privilege information of user test2.
obclient [oceanbase]> SELECT * FROM mysql.db WHERE user='test2' \G
The query result is as follows:
************************* 1. row ***************************
host: %
db: infotest
user: test2
select_priv: N
insert_priv: N
update_priv: N
delete_priv: Y
create_priv: N
drop_priv: N
grant_priv: N
references_priv: N
index_priv: N
alter_priv: N
create_tmp_table_priv: N
lock_tables_priv: N
create_view_priv: N
show_view_priv: N
create_routine_priv: N
alter_routine_priv: N
execute_priv: N
event_priv: N
trigger_priv: N
1 row in set
