I want to revoke update privielges from 2 columns of table "transact". I want the user to have all access to all other tables and data.
mysql> REVOKE UPDATE (system, consumer) ON ledger.transact FROM 'foo'@'localhost';
ERROR 1147 (42000): There is no such grant defined for user 'foo' on host 'localhost' on table 'transaction'
The above does not seem to work.
See Question&Answers more detail:os