Hi, The new CREATE TEMPORARY privilege is a very good idea. Unfortunately, when an user creates a temporary table, he can't write to it if he doesn't also have the INSERT privilege. It would be much more useful if an user were always allowed to write to its own private temporary tables, regardless of his having the INSERT privilege or not. Otherwise the CREATE TEMPORARY privilege loses much of its interest. I want users to be able to create *and* write to temporary tables (this is mandatory until MySQL has subqueries and the like, because users may have to do complex statistics), but I do not want them to be able to mess with public tables.
On a side note : I still have this corruption problem with backups made with FLUSH TABLES WITH READ LOCK. Quite annoying. Regards Antoine. (Filter stuff : sql, query) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
