Access denied: Business Data Connectivity
After creating an External Content Types and connecting the ECT to a list I received the folloing error: Access denied by Business Data Connectivity
I created the ECT with SharePoint designer and give the correct users the correct permissions. Somehow when I saved and modified the ECT from SharePoint designer again, the permissions got lost. I found out that if you modify the ECT in SharePoint designer you need to go back into Central Administration and set permissions again for the Business Data Connectivity Service application.
Follow these steps to give the correct permission on the ECT:
Open the SharePoint 2010 Central Administration on the server and click on Manage service applications.
Then click on Business Data Connectivity Service:
Select the External Content Type and click Set Object Permissions
Add the correct users and give them the right permissions: