Bug #12269 InfSchema table USER_PRIVILEGES show wrong information if GRANT contains dbname
Submitted: 29 Jul 2005 12:21 Modified: 5 Aug 2005 13:23
Reporter: Carsten Segieth Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.10.a/BK source OS:Windows (Windows XP Home (german) SP 2/Linux)
Assigned to: CPU Architecture:Any

[29 Jul 2005 12:21] Carsten Segieth
Description:
When granting access on dbname.* to a user the table INFORMATION_SCHEMA.USER_PRIVILEGES doesn't show correct information:

AFTER granting SELECT only 'USAGE' is shown and 'WITH GRANT OPTION' doesn't change the column from 'NO' to 'YES.

Granting access on *.* seems to change the table INFORMATION_SCHEMA.USER_PRIVILEGES correctly.

How to repeat:
e.g. run attached file

Suggested fix:
show correct results
[29 Jul 2005 12:22] Carsten Segieth
result file

Attachment: pino_13.result (application/octet-stream, text), 15.54 KiB.

[29 Jul 2005 14:38] Carsten Segieth
Priority changed to P2 as the information returned from the system is simply *wrong*.
[5 Aug 2005 13:23] Andrey Hristov
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Hello,
this is not a bug. The MySQL Reference Manual reads :
 "The USER_PRIVILEGES table provides information about global privileges. This information comes from the mysql.user grant table." and
 "The SCHEMA_PRIVILEGES table provides information about schema (database) privileges. This information comes from the mysql.db grant table".
"select * from information_schema.schema_privileges" will show you all the privileges the user has on database(mapped to schema) level.