Hello,

when we create user accounts on our mysql server, then we strictly disallow "CREATE TEMPORARY TABLE".

This said, I was a bit shocked that mysql doesn't really care and allows this command without a problem:

create table x engine = memory;

What is the use to deny users to create a temporary table (which is kept in memory only), when each user is free to consume all memory using the memory-engine for a table?

Regards
Marten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to