Permissions and Security
When working with ECTs, permissions are required in both SharePoint and the external system you are working with. When considering consuming data from an external system, you need to consider what operations your users need to perform against that system. For example, when consuming data from an SQL database, the minimum permissions on the database need to be db_datareader, which enables the user to read from the database. To be able to write back to the same database the user also requires the db_datawriter permission set.
After you have permissions set on the data source, you need to ensure the users have access to the ECT via the BCS Service Application, which is configured via SharePoint Central Administration. To ...
Get Microsoft® SharePoint® Designer 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
