Hi all. I've been trying to grant users the right to create temporary tables:
grant create temporary table on mydatabase.* to user; flush privileges; I've also tried: grant create temporary table on mysql.* to user; flush privileges; When I check in the user table, the Create_tmp_table_priv is not set. If I set this and flush privileges, it still doesn't work. How can I grant this permission? Thanks in advance! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com --------------------------------------------------------------------- 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
