SCHEMA_PRIVILEGES表提供有关schema（数据库）特权的信息。它从mysql.db系统表中获取其值。
SCHEMA_PRIVILEGES表有以下列：
GRANTEE ：授予权限的帐户的名称，格式为“user_name”@“host_name”。TABLE_CATALOG ：schema所属目录的名称。该值始终为def。TABLE_SCHEMA ：schema的名称PRIVILEGE_TYPE：授予的特权。该值可以是可以在schema级别授予的任何权限;请参见“GRANT语法”。每行列出一个权限，因此被授权者拥有每个schema权限一行。IS_GRANTABLE ：如果用户具有GRANT OPTION权限，则为YES，否则为NO。输出不会将GRANT OPTION列为具有PRIVILEGE_TYPE =’GRANT OPTION’的单独行。Notes
SCHEMA_PRIVILEGES表是非标准的INFORMATION_SCHEMA表。以下语句不等价：
mysql> select * from schema_privileges; +-----------------------------+---------------+--------------------+----------------+--------------+ | GRANTEE | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE | IS_GRANTABLE | +-----------------------------+---------------+--------------------+----------------+--------------+ | 'mysql.sys'@'localhost' | def | sys | TRIGGER | NO | | 'mysql.session'@'localhost' | def | performance_schema | SELECT | NO | | 'wanbin'@'192.168.%' | def | test | SELECT | NO | +-----------------------------+---------------+--------------------+----------------+--------------+ 3 rows in set (0.00 sec) mysql> show grants; +---------------------------------------------------------------------+ | Grants for root@localhost | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------+ 2 rows in set (0.00 sec)转载于:https://www.cnblogs.com/wanbin/p/9514628.html
