re: re: Privileges for CREATE TEMPORARY TABLE?

2002-10-08 Thread Victoria Reznichenko
Alec, Saturday, October 05, 2002, 5:14:59 PM, you wrote: Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a global level privilege: http://www.mysql.com/doc/en/News-4.0.2.html AdCaQdC Thank you. That page says that To use these, you must have run the AdCaQdC

re: Privileges for CREATE TEMPORARY TABLE?

2002-10-05 Thread Alec . Cawley
Victoria Reznichenko said: Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a global level privilege: http://www.mysql.com/doc/en/News-4.0.2.html Thank you. That page says that To use these, you must have run the mysql_fix_privilege_tables script after upgrading.

re: Privileges for CREATE TEMPORARY TABLE?

2002-10-02 Thread Victoria Reznichenko
Alec, Tuesday, October 01, 2002, 6:50:31 PM, you wrote: AdCaQdC What privileges do I need for creating a TEMPORARY table? I seem to have AdCaQdC locked myself out of this - and yet I can create permanent tables, which AdCaQdC seems the wrong way round. AdCaQdC N:\mysql -ualec AdCaQdC Welcome to

re: Privileges for CREATE TEMPORARY TABLE?

2002-10-02 Thread Paul DuBois
At 16:24 +0300 10/2/02, Victoria Reznichenko wrote: Alec, Tuesday, October 01, 2002, 6:50:31 PM, you wrote: AdCaQdC What privileges do I need for creating a TEMPORARY table? I seem to have AdCaQdC locked myself out of this - and yet I can create permanent tables, which AdCaQdC seems the wrong

Privileges for CREATE TEMPORARY TABLE?

2002-10-01 Thread Alec . Cawley
What privileges do I need for creating a TEMPORARY table? I seem to have locked myself out of this - and yet I can create permanent tables, which seems the wrong way round. N:\mysql -ualec Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1121 to server