SELECT * FROM `USER_PRIVILEGES` ORDER BY `GRANTEE` DESC
Filter rows: |
GRANTEE ![]() |
TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE | |
---|---|---|---|---|
'root'@'localhost' | def | REPLICATION SLAVE | YES | |
'root'@'localhost' | def | UPDATE | YES | |
'root'@'localhost' | def | REPLICATION CLIENT | YES | |
'root'@'localhost' | def | DELETE | YES | |
'root'@'localhost' | def | CREATE VIEW | YES | |
'root'@'localhost' | def | CREATE | YES | |
'root'@'localhost' | def | SHOW VIEW | YES | |
'root'@'localhost' | def | DROP | YES | |
'root'@'localhost' | def | CREATE ROUTINE | YES | |
'root'@'localhost' | def | RELOAD | YES | |
'root'@'localhost' | def | ALTER ROUTINE | YES | |
'root'@'localhost' | def | SHUTDOWN | YES | |
'root'@'localhost' | def | CREATE USER | YES | |
'root'@'localhost' | def | PROCESS | YES | |
'root'@'localhost' | def | EVENT | YES | |
'root'@'localhost' | def | FILE | YES | |
'root'@'localhost' | def | TRIGGER | YES | |
'root'@'localhost' | def | REFERENCES | YES | |
'root'@'localhost' | def | CREATE TABLESPACE | YES | |
'root'@'localhost' | def | INDEX | YES | |
'root'@'localhost' | def | ALTER | YES | |
'root'@'localhost' | def | DELETE HISTORY | YES | |
'root'@'localhost' | def | SHOW DATABASES | YES | |
'root'@'localhost' | def | SUPER | YES | |
'root'@'localhost' | def | CREATE TEMPORARY TABLES | YES |
Filter rows: |