pl1ght
02-06-2003, 04:05 PM
Ok, im working with a few thousand tables here. What i want to do is be able to grant a user access to ALL tables except one. Without having to have the hassle of granting each user access to each table one by one. Ive thought to write a script that would loop through all the tables and insert to mysql.tables_priv, but somehow that just doesnt seem right. There has to be something i can insert in that one table that would deny access to the users with Grant access to all the other tables. Anyone have any suggestions on this? Thanks.