Time ago I submit a post about temp tables and rights privileges and
it's in my head still.
There is an user privilege to create temporary table
(create_tmp_table_priv) but when the "owner of the table" need drop
this table can't do (if have drop priv can, but it's a bomb time).
Someone have an ide
I'll be fighting with rights over tmp tables time ago, basically I want give full temporary tables management but not for other all tables, including select right.
The only way to do that work was insert in tables_priv for each user a "user/tmp_table_name" record granting full privileges.
ALUES ('host.localdomain','db1','user1','TMP_Liq', USER(), 'Select,Insert,Update,Delete,Alter,Drop,Index','')
and this work!
Alejandro
---Mensaje original---
De: Matt W
Fecha: sábado 13 de diciembre de 2003 22:36:54
A: adburne
le to TRUNCATE it, I think.
And actually, if you can TRUNCATE the other tables (if the DELETE
privilege allows it), isn't that just as bad as DROPping them? :-)
Matt
- Original Message -
From: adburne
To: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 11:31 AM
Subject: Temporary tab
Hi, I'm granting users to use temporary tables as:
GRANT CREATE TEMPORARY TABLES ON db1.* TO user1;
and having grants on many other tables as:
GRANT SELECT, INSERT, UPDATE, DELETE ON db1.table1 TO user1;
GRANT SELECT, INSERT, UPDATE, DELETE ON db1.table2 TO user1;
but how make t
