Thank you for the fine bug report.
We shall fix it soon.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ w
I give file access to a user on tables in a database :
GRANT INSERT,SELECT,FILE ON LOGS.* TO www@localhost identified by
'hidden';
then :
SHOW GRANTS www@localhost;
+---+
| Grants for www@localhost
>Description:
Granting a normal user FILE privilege will be listed as DROP
and user has both FILE and DROP privileges.
>How-To-Repeat:
mysql -u root -p
CREATE DATABASE TEST1;
USE TEST1;
CREATE TABLE TESTING (COL1 CHAR(3) );
GRANT INSERT,SELECT,FILE
