: 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 has security impacts (maybe
automatically granting other rights), which ones?
The mysql documentation doesn't tell much
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
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
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/proc-id.table-name instead?
Actually I was just reading through