SmartConnect Error: “The delete permission was denied on the object…”

A while back a client using SmartConnect reported an error running one integration; this is one of a set of newly created identical integrations running against a set of companies, but only one of them was failing.

The error produced was:

As there was a reference to permssions, I assumed there would be a SQL issue; when looking through database permissions, I found that in one database the user account used by SmartConnect had the db_denydatawriter role membership assigned:

Once this permission was removed, the integration ran successfully.

Read original post SmartConnect Error: “The delete permission was denied on the object…” at azurecurve|Ramblings of a Dynamics GP Consultant