If you can retrieve information but not insert, update or delete rows, then the first thing to do is look at the permissions your connection user has been permitted - it may be that your user does not have delete permission.
It is normal to use the minimum possible permissions for security purposes:
Principle of least privilege[
^]