Entry

How can I stop the DELETE command from working on a table?

Can I stop users from deleting rows from a table?

Feb 8th, 2000 07:52
Nathan Wallace, Sinisa Milivojevic

Luckily MySQL's GRANT/ REVOKE is quite powerfull.

You can revoke DELETE privileges from all users on all databases, and
then grant DELETE privilege only on those tables where you would like
to allow users perform  DELETE opetation.

MySQL's GRANT / REVOKE system covers global, database, table and
column level. 

Read a manual on the subject.