SELECT * FROM `SCHEMA_PRIVILEGES`
ORDER BY `SCHEMA_PRIVILEGES`.`TABLE_SCHEMA` ASC
过滤行: |
GRANTEE | TABLE_CATALOG | TABLE_SCHEMA 1 | PRIVILEGE_TYPE | IS_GRANTABLE | |
---|---|---|---|---|---|
'mysqld'@'%' | def | mysql | INSERT | YES | |
'server'@'%' | def | mysql | ALTER ROUTINE | YES | |
'root'@'%' | def | mysql | DELETE | YES | |
'mysqld'@'%' | def | mysql | TRIGGER | YES | |
'mysqld'@'%' | def | mysql | REFERENCES | YES | |
'root'@'%' | def | mysql | ALTER | YES | |
'server'@'%' | def | mysql | CREATE | YES | |
'server'@'%' | def | mysql | CREATE TEMPORARY TABLES | YES | |
'mysqld'@'%' | def | mysql | EXECUTE | YES | |
'root'@'%' | def | mysql | SHOW VIEW | YES | |
'mysqld'@'%' | def | mysql | SELECT | YES | |
'server'@'%' | def | mysql | CREATE ROUTINE | YES | |
'root'@'%' | def | mysql | UPDATE | YES | |
'mysqld'@'%' | def | mysql | EVENT | YES | |
'mysqld'@'%' | def | mysql | DROP | YES | |
'root'@'%' | def | mysql | INDEX | YES | |
'server'@'%' | def | mysql | DELETE | YES | |
'server'@'%' | def | mysql | ALTER | YES | |
'mysqld'@'%' | def | mysql | LOCK TABLES | YES | |
'root'@'%' | def | mysql | CREATE VIEW | YES | |
'server'@'%' | def | mysql | SHOW VIEW | YES | |
'root'@'%' | def | mysql | INSERT | YES | |
'mysqld'@'%' | def | mysql | ALTER ROUTINE | YES | |
'root'@'%' | def | mysql | TRIGGER | YES | |
'mysqld'@'%' | def | mysql | CREATE | YES |
过滤行: |