Hello, Is there any way to grant a user only SELECT permissions on a set of tables in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the Database itself??
What I want is a database where the users cannot modify the core tables, but I want them to be able to CREATE and DROP temporary tables that they have created?!? Any help would be great.. Thanks, Chris --------------------------------------------------------------------- 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