The Following are the MySQL Data Manipulation Privileges from least powerful to most powerful
SELECT: View Data in the Database, Most Users need this to use the Database
INSERT: Needed to add data to a table, Data entry people will need this right
UPDATE: Needed to change data, Grant or not depending on how you do revisions
DELETE: Needed to remove data, this privilege should not be given to regular users
EXECUTE: Allows execution of Stored Procedure or Functions, limit access to it