SELECT * FROM `USER_PRIVILEGES` ORDER BY `TABLE_CATALOG` ASC
Filtrer les lignes: |
GRANTEE | TABLE_CATALOG ![]() | PRIVILEGE_TYPE | IS_GRANTABLE | |
---|---|---|---|---|
'root'@'localhost' | def | SHOW DATABASES | YES | |
'root'@'::1' | def | LOCK TABLES | YES | |
'root'@'127.0.0.1' | def | REPLICATION CLIENT | YES | |
'root'@'::1' | def | SELECT | YES | |
'root'@'127.0.0.1' | def | DELETE | YES | |
'root'@'127.0.0.1' | def | CREATE | YES | |
'root'@'localhost' | def | SUPER | YES | |
'root'@'::1' | def | EXECUTE | YES | |
'root'@'127.0.0.1' | def | CREATE VIEW | YES | |
'root'@'::1' | def | INSERT | YES | |
'root'@'127.0.0.1' | def | DROP | YES | |
'root'@'localhost' | def | CREATE TEMPORARY TABLES | YES | |
'root'@'::1' | def | REPLICATION SLAVE | YES | |
'root'@'127.0.0.1' | def | SHOW VIEW | YES | |
'pma'@'localhost' | def | USAGE | NO | |
'root'@'::1' | def | UPDATE | YES | |
'root'@'127.0.0.1' | def | RELOAD | YES | |
'root'@'localhost' | def | LOCK TABLES | YES | |
'root'@'::1' | def | REPLICATION CLIENT | YES | |
'root'@'127.0.0.1' | def | CREATE ROUTINE | YES | |
'root'@'localhost' | def | SELECT | YES | |
'root'@'::1' | def | DELETE | YES | |
'root'@'127.0.0.1' | def | SHUTDOWN | YES | |
'root'@'localhost' | def | EXECUTE | YES | |
'root'@'::1' | def | CREATE VIEW | YES |
Filtrer les lignes: |