[Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv

[Marc Delisle]

Rabus wrote:

> -----Original Message-----
> From: Robin H. Johnson
> 
>>having global CREATE TEMP TABLE, you can use that on ANY db,
>>
> 
> Nope!
> CREATE TEMPORARY TABLES is just a flag that manages if a user may use
> the TEMPORARY keyword when creating a table.
> It does NOT bypass the CREATE privilege which is still required for
> creating temporary tables.
> 
> When running MySQL's upgrade script, the CREATE TEMPORARY TABLES
> privilege is automatically granted to each user because this is actually
> the setting in MySQL 3.23.
> 
> Alexander M. Turek
> <alex at bugfixes.info>

Alexander,

so, why can a user do USE MYSQL when he has CREATE TEMPORARY TABLES?

Marc