restricting privileges on tables

[Michael Aldrich]

We have several applications on a database accessed by the same functional user. We are decommissioning one but we want to limit access to read only. Modifying the code is not possible but it was suggested that removing update/insert/delete privilege on the underlying tables for this application might be sufficient.

That's where we need help. The functional user has full privileges on all tables in the database. Is there an easy way to remove insert/update/delete only on those tables. Here is the access privileges for the user:

GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'XXX';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `database`.* TO 'user'@'%';

mike aldrich
washtenaw community college
[e-mail]