Re: question on create_tmp_table_priv

2006-11-14 Thread Ryan Stille
Marten Lehmann wrote: that is the sort of thing that I expected and was afraid of. Also, I think the mysql documentation doesn't really point out that temporary tables are always kept in memory. Couldn't mysql create them in /tmp/. instead? Actually I was just reading through the docs about thi

Re: question on create_tmp_table_priv

2006-11-14 Thread Marten Lehmann
Hello, > If a person forgets to drop temp tables and stays within a connection for hours or even days, memory resources can be overloaded a lot of temp tables. Furthermore, loading temp tables with a GB of data is bad practice but is possible under such circumstances. that is the sort of thin

question on create_tmp_table_priv

2006-11-14 Thread Marten Lehmann
Hello, if there are not any security impacts, why does the Create_tmp_table-privilege exist separately to the create_table-privilege? Or if it has security impacts (maybe automatically granting other rights), which ones? The mysql documentation doesn't tell much about this. Regards Marten

Re: question on create_tmp_table_priv

2006-11-14 Thread Rolando Edwards
EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, November 14, 2006 10:49:57 AM GMT-0500 US/Eastern Subject: question on create_tmp_table_priv Hello, if there are not any security impacts, why does the Create_tmp_table-privilege exist separately to the create_table-privilege? Or if it ha