System Account not having permission to update external list via BCS

Question

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?

Answer 1

Firstly, please check the account which starts the workflow has enough permission on the external list. (If the workflow starts automatically when new item created, please check the account that created the item. If workflow starts when item is changed, then check the account that modified the item.)

Read more details here. Also check this blog to narrow down it.