Scenario:
Getting Error “Access Denied by Business Data Connectivity”, while loading the External List.
Solution:
Go to Central Administration -> Application Management -> Manage Service Applications -> Business Data Connectivity Service
Select the Store and Click on Set Metadata store permissions.
Select the User and choose appropriate permissions.
You are set to go now. J
