When you create an external list and try to browse to it, you get an Access Denied error.
You need to configure permissions on the BCS connection under Central Administration.
- Go to Central Administration -> Manage Service Applications -> Business Data Connectivity Service.
- Select your BCS connection -> Edit -> Set Object Permissions.
- Add the required permissions.
- Click OK.
You should now be able to see your external list.