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: | |
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
[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.