By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,825 Members | 1,456 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,825 IT Pros & Developers. It's quick & easy.

MySQL tempory table rights

P: n/a
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";

Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.