Chris, Thursday, April 18, 2002, 8:50:06 PM, you wrote: CS> Is there any way to grant a user only SELECT permissions on a set of tables CS> in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the CS> Database itself??
CS> What I want is a database where the users cannot modify the core tables, but CS> I want them to be able to CREATE and DROP temporary tables that they have CS> created?!? Yes, you can set SELECT privilege on some tables and CREATE, DROP, INSERT privileges on the certain database. Use GRANT statement, look at: http://www.mysql.com/doc/G/R/GRANT.html Note: if you set SELECT privileges on some tables (f.e. table1 and table2), your users don't have SELECT privileges on tables, that will be created by themself ... So, you need to correct privileges on new tables or to set SELECT privileges on the whole database ... CS> Any help would be great.. CS> Thanks, CS> 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
