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';
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)