One database, multiple tables. I need to limit access to one table per user, but also allow all other tables to be accessed by all users. For example:
Say I have 5 users: usera, userb, userc, userd, usere Table 1 - all 5 users, select, inset, update, delete Table 2 - all 5 users, select, inset, update, delete Table 3 - only userc, select, inset, update, delete When I add in a new table, such as table 4, I would like it to be all 5 users. So basically, I just want to lock out one table, and allow only one user to that table. I have tried several ways, and read over the docs, and I am just not seeing how to make this work. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]