[Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv

[Rabus]

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

+-----------------------------+
| The phpMyAdmin Project      |
| http://www.phpmyadmin.net   |
| rabus at users.sourceforge.net |
+-----------------------------+
| [bugfixes.info]             |
| http://www.bugfixes.info    |
| rabus at bugfixes.info         |
+-----------------------------+