[Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv

Marc Delisle delislma at CollegeSherbrooke.qc.ca
Fri Mar 21 11:10:09 CET 2003

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>


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


More information about the Developers mailing list