SELECT * FROM `SCHEMA_PRIVILEGES` ORDER BY `PRIVILEGE_TYPE` DESC
Filtrar filas: |
GRANTEE | TABLE_CATALOG | TABLE_SCHEMA |
PRIVILEGE_TYPE ![]() |
IS_GRANTABLE | |
---|---|---|---|---|---|
'pma'@'localhost' | def | phpmyadmin | UPDATE | NO | |
''@'%' | def | test\_% | UPDATE | NO | |
''@'%' | def | test | UPDATE | NO | |
''@'%' | def | test\_% | TRIGGER | NO | |
''@'%' | def | test | TRIGGER | NO | |
''@'%' | def | test | SHOW VIEW | NO | |
''@'%' | def | test\_% | SHOW VIEW | NO | |
'pma'@'localhost' | def | phpmyadmin | SELECT | NO | |
''@'%' | def | test\_% | SELECT | NO | |
''@'%' | def | test | SELECT | NO | |
''@'%' | def | test | REFERENCES | NO | |
''@'%' | def | test\_% | REFERENCES | NO | |
''@'%' | def | test | LOCK TABLES | NO | |
''@'%' | def | test\_% | LOCK TABLES | NO | |
'pma'@'localhost' | def | phpmyadmin | INSERT | NO | |
''@'%' | def | test\_% | INSERT | NO | |
''@'%' | def | test | INSERT | NO | |
''@'%' | def | test | INDEX | NO | |
''@'%' | def | test\_% | INDEX | NO | |
''@'%' | def | test\_% | EVENT | NO | |
''@'%' | def | test | EVENT | NO | |
''@'%' | def | test | DROP | NO | |
''@'%' | def | test\_% | DROP | NO | |
''@'%' | def | test | DELETE | NO | |
'pma'@'localhost' | def | phpmyadmin | DELETE | NO |
Filtrar filas: |