At 18:28 -0500 3/25/02, Ray Rodriguez wrote:
>This is either a mysql feature request (who would I send it to?) or a
>question.  I've looked at the documentation and could not find a way to do
>this. 
>
>Is there a way to grant create/drop access specifically for temporary
>tables? I have a situation where I need to use a create temporary..select
>statement and later use a select statement to get some data, and later
>drop the temporary table.  I would like to do this without giving create
>and especially drop access to the regular non-temporary tables in the
>database.

You could set up another database that's used only for temporary tables
and create the tables there.

>
>Thanks,
>Ray Rodriguez


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

Reply via email to