SELECT * FROM `USER_PRIVILEGES` ORDER BY `IS_GRANTABLE` DESC
Filtrar filas: |
GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE |
IS_GRANTABLE ![]() |
|
---|---|---|---|---|
'root'@'127.0.0.1' | def | DELETE HISTORY | YES | |
'root'@'localhost' | def | RELOAD | YES | |
'root'@'::1' | def | FILE | YES | |
'root'@'127.0.0.1' | def | ALTER | YES | |
'root'@'localhost' | def | CREATE ROUTINE | YES | |
'root'@'::1' | def | EVENT | YES | |
'root'@'localhost' | def | SHUTDOWN | YES | |
'root'@'::1' | def | REFERENCES | YES | |
'root'@'127.0.0.1' | def | SHOW DATABASES | YES | |
'root'@'localhost' | def | ALTER ROUTINE | YES | |
'root'@'::1' | def | TRIGGER | YES | |
'root'@'localhost' | def | PROCESS | YES | |
'root'@'::1' | def | INDEX | YES | |
'root'@'127.0.0.1' | def | SUPER | YES | |
'root'@'localhost' | def | CREATE USER | YES | |
'root'@'::1' | def | CREATE TABLESPACE | YES | |
'root'@'::1' | def | DELETE HISTORY | YES | |
'root'@'localhost' | def | FILE | YES | |
'root'@'::1' | def | ALTER | YES | |
'root'@'127.0.0.1' | def | CREATE TEMPORARY TABLES | YES | |
'root'@'localhost' | def | EVENT | YES | |
'root'@'127.0.0.1' | def | SELECT | YES | |
'root'@'localhost' | def | REFERENCES | YES | |
'root'@'::1' | def | SHOW DATABASES | YES | |
'root'@'127.0.0.1' | def | LOCK TABLES | YES |
Filtrar filas: |