COLUMN_PRIVILEGES table provides
information about column privileges. This information comes from
mysql.columns_priv grant table.
In the output from
COLUMNS, the privileges are all in one field and in
lowercase, for example,
COLUMN_PRIVILEGES, there is one
privilege per row, in uppercase.
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES SHOW GRANTS ...
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices