Hi,
(FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
After extensive testing, I have found that: -
(a) [SIDE ISSUE]
Logged-in as a user (using password) and modifying privileges in
another MySQL (root) session, even with "flush privileges", the
privileges do not reliably update in all cases. Not all
combinations of GRANT / REVOKE completely without sometimes
needing a flush privileges, even in a single (root) session.
(b) [MAIN ISSUE]
One might expect a statement such as the following type of
statement: SELECT fields INTO OUTFILE "/tmp/j" FROM tbl; to
require the FILE privilege (global) and the SELECT privilege on
_just_ the affected table. Not true. In my tests, I had to grant
the SELECT privilege on the entire (affected) database instead.
Hope this helps. (Anyone know any more?)
Note, from changelog, I cannot find a fix for this problem. Having
searched for "outfile" and "privilege", I have found only the
following vaguely related (but not relevant!) fix: -
(Release 3.23.25) - Fixed privilege checking for CHECK TABLE.
--
Best regards,
James.
---------------------------------------------------------------------
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
