(mysql.info.gz) USER_PRIVILEGES Table
Info Catalog
(mysql.info.gz) STATISTICS Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) SCHEMA_PRIVILEGES Table
21.1.5 The `INFORMATION_SCHEMA USER_PRIVILEGES' Table
-----------------------------------------------------
The `USER_PRIVILEGES' table provides information about global
privileges. This information comes from the `mysql.user' grant table.
*Standard Name* *`SHOW' name* *Remarks*
`GRANTEE' e.g. 'user'@'host'
`TABLE_CATALOG' `NULL'
`PRIVILEGE_TYPE'
`IS_GRANTABLE'
Notes:
* This is a non-standard table. It takes its values from the
`mysql.user' table.
Info Catalog
(mysql.info.gz) STATISTICS Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) SCHEMA_PRIVILEGES Table
automatically generated byinfo2html