MySQL tempory table rights

[david]

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";

[david]

Re: MySQL tempory table rights

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@loca lhost' 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