title: “MySQL Drop rights only on Table”
date: 2020-01-02T11:49:22
slug: mysql-drop-rights-only-on-table

REVOKE ALL PRIVILEGES ON `cstx`.\* FROM 'cstx'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `cstx`.\* TO 'cstx'@'%';
GRANT DROP ON TABLE cstx.\* TO cstx