SharePoint 2013 Business Connectivity Services Access Denied Error

In SharePoint 2013, If you have setup Business Connectivity Services, or BCS for short, and now you are trying to access an external content type in a list but you get “Access denied by Business Data Connectivity”, here is you will solve it.

 

 This error occurs because the logged in user does not have permissions on the external content type that you had created. To resolve the issue go to central administration site and give permissions to specific users on the external content type.

1.       Open SharePoint Central Admin site.

2.       Click Application Management.

3.       In Service Applications section, click Manage service applications.

4.       Click Business Data Connectivity Service.

5.       You will see your external content type listed on this page. Select it (by checking the box) and click Set Object Permissions button in the ribbon.

 6.       This will open a dialog box. Enter username that you want to give permission to in the box and click Add. Select the added user in the box below and select permissions for that user by checking the boxes against the listed permissions. Depending on the type of user, you can select which permissions to give. For example, giving them Execute permission will let them see the results. If the user is admin type, then give them all the permissions. Lastly, check the box at the bottom to “propagate” permissions to all methods of the external content type. Click OK to save the settings.

 

 

 Also, if you want to give access to all users in the organization, add NT Authority\Authenticated Users in the box at the top and click Add and then assign desired permissions as described above. When you add authenticated users, you see All Users (windows) listed as one of the users.