SELECT * FROM `SCHEMA_PRIVILEGES`
GRANTEE | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE | IS_GRANTABLE | |
---|---|---|---|---|---|
''@'%' | def | test | SELECT | NO | |
''@'%' | def | test | INSERT | NO | |
''@'%' | def | test | UPDATE | NO | |
''@'%' | def | test | DELETE | NO | |
''@'%' | def | test | CREATE | NO | |
''@'%' | def | test | DROP | NO | |
''@'%' | def | test | REFERENCES | NO | |
''@'%' | def | test | INDEX | NO | |
''@'%' | def | test | ALTER | NO | |
''@'%' | def | test | CREATE TEMPORARY TABLES | NO | |
''@'%' | def | test | LOCK TABLES | NO | |
''@'%' | def | test | CREATE VIEW | NO | |
''@'%' | def | test | SHOW VIEW | NO | |
''@'%' | def | test | CREATE ROUTINE | NO | |
''@'%' | def | test | EVENT | NO | |
''@'%' | def | test | TRIGGER | NO | |
''@'%' | def | test\_% | SELECT | NO | |
''@'%' | def | test\_% | INSERT | NO | |
''@'%' | def | test\_% | UPDATE | NO | |
''@'%' | def | test\_% | DELETE | NO | |
''@'%' | def | test\_% | CREATE | NO | |
''@'%' | def | test\_% | DROP | NO | |
''@'%' | def | test\_% | REFERENCES | NO | |
''@'%' | def | test\_% | INDEX | NO | |
''@'%' | def | test\_% | ALTER | NO |