My SharePoint administrator granted permissions to services, sp app pool, sp farm adim, and secure store in BCS for me to use but was only able create/delete but not update. I use SharePoint designer 2013 list workflow to create/delete external list item on SQL DB but not update. Got permission message on System Account when delete:
The workflow could not update the item in the external data source. Make sure the user has permissions to access the external data source and update items.
We reviewed the Posting and double checked our steps but still no avail. Anyone have similar issues or ideas on how to troubleshoot and fix?