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
