Daniel, Wednesday, July 17, 2002, 8:20:30 AM, you wrote: DK> I've been trying to grant users the right to create temporary tables:
DK> grant create temporary table on mydatabase.* to user; DK> flush privileges; DK> I've also tried: DK> grant create temporary table on mysql.* to user; DK> flush privileges; DK> When I check in the user table, the Create_tmp_table_priv is not set. If DK> I set this and flush privileges, it still doesn't work. DK> How can I grant this permission? CREATE TEMPORARY TABLES is a global privilege, not a database ... GRANT CREATE TEMPORARY TABLES ON *.* TO 'user'@'host' IDENTIFIED BY 'password'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
