Hi, When one is doing a GRANT statement at the database level the database name is stored in mysql.db in lowercase letters only, regardless of the upper/lowercase characters used for the database name at the GRANT statement.
Example: GRANT SELECT ON SYSMON.* TO theUser@% results in having stored the database name "SYSMON" as "sysmon" at mysql.db, column db. GRANT SELECT ON SysMon.* TO theUser@% will grant the privilege to the same database "sysmon" as the statement above. On a Unix plattform there can be two different databases "SYSMON" and "SysMon"! Furthermore, if one manually changes the database name back to the original name - "SYSMON" - at the column mentioned above and re-run the statement there is a second entry generated in mysql.db: the old one having "SYSMON" and the new one having "sysmon" as database name. As the database name is case-sensitive in Unix systems this is critical. I'm running on Win XP, and found this behavior in mysql-MAX NT versions 4.0.2 to 4.0.4. Is this a Bug or intended behaviour? Best regards, Wolf --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
