21 Mar
2003
21 Mar
'03
11:10 a.m.
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@bugfixes.info
Alexander,
so, why can a user do USE MYSQL when he has CREATE TEMPORARY TABLES?
Marc