I want to give GRANT permission on UPDATE and DELETE , after that i want to revoke an UPDATE. But when i want to make UPDATE mysql allow to change what i want. I want when i revoke UPDATE so i cant make any UPDATE on table sett by user "ivanivan" Please can you help me about it?
GRANT UPDATE,DELETE ON usc.sett TO 'ivanivan'@'localhost';
REVOKE delete , update ON usc.sett FROM 'ivanivan'@'localhost';
update usc.sett set trgt=83 where settid=1
SHOW GRANTS FOR 'ivanivan'@'localhost';