30.4.3 通过查询information_schema数据库查看用户权限
在MySQL 5.0版本之后,支持通过nformation_schema数据库查看用户权限,例如,查看binghe用户所具有的权限。
mysql> SELECT * FROM information_schema.SCHEMA_PRIVILEGES WHERE GRANTEE = "'binghe'@'localhost'" \G
*************************** 1. row ***************************
GRANTEE: 'binghe'@'localhost'
TABLE_CATALOG: def
TABLE_SCHEMA: goods
PRIVILEGE_TYPE: SELECT
IS_GRANTABLE: YES
*************************** 2. row ***************************
GRANTEE: 'binghe'@'localhost'
TABLE_CATALOG: def
TABLE_SCHEMA: goods
PRIVILEGE_TYPE: INSERT
IS_GRANTABLE: YES
*************************** 3. row ***************************
GRANTEE: 'binghe'@'localhost'
TABLE_CATALOG: def
TABLE_SCHEMA: goods
PRIVILEGE_TYPE: UPDATE
IS_GRANTABLE: YES
*************************** 4. row ***************************
GRANTEE: 'binghe'@'localhost'
TABLE_CATALOG: def
TABLE_SCHEMA: goods
PRIVILEGE_TYPE: DELETE
IS_GRANTABLE: YES
4 rows in set (0.00 sec)
结果显示,binghe用户对goods数据库具有增、删、改、查权限。