O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required