>>>>> "Richard" == Richard Ellerbrock <richarde@stripped> writes:
Richard> I want to restrict access to a database for read only access via ODBC. This
> works just great with 3.23.2 alpha. The only problem is that I need to create a temporary
> table for some of my queries. This fails with an access denied message. To get around
> this, I need to allow create and drop access on the database which blows the security. Are
> there plans to add a "Create Temp" access attribute?
Richard> Richard Ellerbrock
One option is to make a database 'temp' that anyone is allowed to use.
In this case you can always do:
CREATE TEMPORARY TABLE temp.t1 (a int,...)