Chris, Wednesday, May 01, 2002, 5:18:47 PM, you wrote: CA> I have a user account that needs to create and subsequently drop tables (not CA> temporary tables).
CA> Is it possible to give permissions to this user to drop just the tables that CA> he creates - without allowing him to drop any other table ? The easiest way is to give your user an individual database with necessary permissions on this database. If you want to use one database for all users you can give "create" privileges on this database for user and then add "drop" privileges on his tables after table creation. CA> Thanks, CA> Chris -- For technical support contracts, goto https://order.mysql.com/ 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