Microsoft SharePoint Server 2010 and the Microsoft Office 2010 suites include Microsoft Business Connectivity Services, which are a set of services and features that provide a way to connect SharePoint solutions to sources of external data and to define external content types that are based on that external data.
Recently I was giving training to group of people on BCS (Business Data Connectivity) functionality and I've been getting a few questions from people who have been trying this out, but stumbled onto some problems with it in terms of permissions when they tried it out themselves.
When you've created your external list and try to access it (even as the same user, Administrator which created it) you might get the following error:
If you are facing the same problem then here is the solution that you are looking for:
§ Central Administration
§ Application management
§ Manage service applications
§ Business Data Connectivity Service
§ Your Entity
§ Set Permissions
§ Now set the permissions as per your project requirements, You might want to use different permissions in your environments
In my farm, I am using this:
That’s it and you are done:
You should now be able to access the external list and see the desired result.
If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you
