Neil, Thank you for your suggestion. Unfortunately, the Grant command grants privileges to lower case table names also. I have also tried to find solution from archive of mysql mail lists but nothing useful have been found.
Kent. --- Neil Silvester <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Mr Kent Cheung > > [mailto:[EMAIL PROTECTED]] > > > > > > >SELECT * FROM Company; > > > > > >Then, an error occurs that tells me that the user > > xxx > > >is not allowed select the table. Of course, there > > is > > >no error when the following SQL is submitted: > > > > > >SELECT * FROM company; > > > > > >I change my.cnf back and repeat the above tests > and > > >the error persists. Thus, nothing seems to be > > changed > > >by setting the variable. > > > > I am not quite sure but, if you had set table > > privileges for your tables > > using grant statements, these could be incorrectly > > pointing to the wrong > > databases still. > > So if you granted > > GRANT ALL ON xxx.Company TO user@host IDENTIFIED > BY > > "password" > > you would get errors because you only have > > permission to Company and not > > company. > > > > Just a thought. > > > > Neil Silvester > > Heat and Control Pty Ltd > > > __________________________________________________ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com --------------------------------------------------------------------- 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
