Note
This view is available starting with V1.4.
Purpose
This view displays database-level privileges.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| host | varchar(128) | NO | The host name. |
| db | varchar(128) | NO | The database name. |
| 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 perform grant operations. |
| reference_priv | varchar(1) | NO | This column is not in use. |
| index_priv | varchar(1) | NO | Indicates whether the user can create an index. |
| 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 a temporary table. This column is not in use. |
| lock_tables_priv | varchar(1) | NO | Indicates whether the user can execute the LOCK TABLES statement. The user also needs select privileges on the tables. This column is not in use. |
| 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 in use. |
| alter_routine_priv | varchar(1) | NO | Indicates whether the user can execute the alter function statement. This column is not in use. |
| execute_priv | varchar(1) | NO | Indicates whether the user can execute stored procedures. This column is not in use. |
| event_priv | varchar(1) | NO | Indicates whether the user can create, delete, or modify events. This column is not in use. |
| trigger_priv | varchar(1) | NO | Indicates whether the user can execute the create trigger or drop trigger statement. This column is not in use. |
Sample query
Query the database-level privileges 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