To remove UPDATE, INSERT and DELETE privileges : REVOKE « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. REVOKE
REVOKE INSERT,UPDATE,DELETE
 ON myDatabase.*
 FROM bad@localhost;








27.6.REVOKE
27.6.1.Revoking privileges
27.6.2.To remove UPDATE, INSERT and DELETE privileges
27.6.3.Removing Permissions from a Database
27.6.4.No other database can allow any user to connect from any host.
27.6.5.Removing Permissions from a User