Configuring Business Data Connectivity Service Permissions

When you have deployed your external content types to the Business Data Connectivity (BDC) service application, you must configure permissions on each individual external content type. You can assign the following permissions to users or groups on each external content type:

  • Edit. This permission enables the user or group to edit the external content type definition.
  • Execute. This permission enables the user or group to use the operations defined by the external content type, such as create, readitem, update, delete, and read list.
  • Selectable in clients. This permission enables the user or group to create an external list from the external content type. It also enables users to use the external content type Picker control.
  • Set Permissions. This permission enables the user or group to manage permissions on the external content type.

The following illustration shows an example.

Setting permissions on an external content type

Ff798450.d97f4153-4a9e-4b2c-826c-563025be7eac(en-us,PandP.10).png

The key thing to remember is that your external content type might need to support requests from both inside and outside the sandbox environment. If you want to support requests for external data from sandboxed solutions, you must assign Execute permissions to the user code proxy service account. If you want to support requests for external data from non-sandboxed components, you must assign Execute permissions to the site users or groups who require access to the data.

For more information about setting permissions on external content types, see Manage external content types (SharePoint Server 2010) on TechNet.

Show: