I keep getting the error: ERROR 1147: There is no such grant defined for user 'username' on host 'host.example.com' on table 'orders_npfs'
> Sean, > As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states, > REVOKE ALL ON `database`.`table` FROM 'user'@'hostname'; > > >> MySQL - 4.0.18-standard-log > > How do you revoke all privileges from a user for one table in a database, > and still maintain the existing privileges for the other tables? > > For example, I have these tables: > Email > Logbook > Sales_tax > Sessions > Transactions > Users > Orders_A > Orders_B > > Lets say I have two users, user_A and user_B > Currently, both users have select, insert, update, and delete on all tables. > I want to totally block user_A from touching Orders_B and totally block > user_B from touching Orders_A > > Knowing how to do this the SQL way would help, ultimately, I have to show a > client how to do this in phpMyAdmin, so if anyone knows how to do it in > there, that would be nice as well. -- ------------------------------------------------------------- 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]