Sorry, my post got cut...
I had a problem with this query (MySQL-4.1.0-alpha-standard):
$query = "SELECT `id` , `date`, `date_added`, `title` " .
"FROM ( " .
" SELECT *, COALESCE(`date`, `date_added`) AS `date_` " .
" FROM table " .
" ) AS temp_table " .
"ORDER BY `date_` DESC";
I was getting this error:
select command denied to user: 'moderator@localhost' for table
'/var/tmp/#sql_1d3_0'
And i found at:
http://www.mysql.com/doc/en/Privileges_provided.html
Posted by phadeguy on Tuesday April 2 2002, @7:39am
I'm running into the situation where it would be
really nice for a connection to only have the
ability to SELECT and create/drop/insert/delete
TEMPORARY tables without having the privileges to
do this globally with all objects. I didn't see
this option listed in any current or upcoming
release. Can this function be implemented in
some sooner upcoming release? I think others
might find it useful as well.
It's dated April 2002! And i can't find a way do it now other
than granting global select access to my moderator account.
If you now a better a way, plz tell me
Thx
--
David