SELECT * FROM `SCHEMA_PRIVILEGES`
ORDER BY `SCHEMA_PRIVILEGES`.`IS_GRANTABLE` ASC
过滤行: |
GRANTEE | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE | IS_GRANTABLE 1 | |
---|---|---|---|---|---|
''@'%' | def | test\_% | LOCK TABLES | NO | |
''@'%' | def | test | LOCK TABLES | NO | |
''@'%' | def | test\_% | TRIGGER | NO | |
''@'%' | def | test | TRIGGER | NO | |
''@'%' | def | test\_% | CREATE | NO | |
''@'%' | def | test | CREATE | NO | |
'pma'@'localhost' | def | phpmyadmin | DELETE | NO | |
''@'%' | def | test\_% | CREATE TEMPORARY TABLES | NO | |
''@'%' | def | test | CREATE TEMPORARY TABLES | NO | |
''@'%' | def | test\_% | EVENT | NO | |
''@'%' | def | test | EVENT | NO | |
''@'%' | def | test\_% | DELETE | NO | |
''@'%' | def | test | DELETE | NO | |
'pma'@'localhost' | def | phpmyadmin | UPDATE | NO | |
''@'%' | def | test\_% | ALTER | NO | |
''@'%' | def | test | ALTER | NO | |
''@'%' | def | test\_% | CREATE ROUTINE | NO | |
''@'%' | def | test | CREATE ROUTINE | NO | |
''@'%' | def | test\_% | UPDATE | NO | |
''@'%' | def | test | UPDATE | NO | |
'pma'@'localhost' | def | phpmyadmin | INSERT | NO | |
''@'%' | def | test\_% | INDEX | NO | |
''@'%' | def | test | INDEX | NO | |
''@'%' | def | test\_% | SHOW VIEW | NO | |
''@'%' | def | test | SHOW VIEW | NO |
过滤行: |