Reading and Saving as Template of a List created from ECT

asked 2021-04-12T07:12:28.933+00:00
Dieter Tontsch 976 Reputation points

Working with an External List in SharePoint (2019 on-prem), I have the following questions:

  • What Permission are required for an user in order to view the content of an External List which gets it's data based on an ECT of an MSSQL table or view. Has this anything to do with Metadata Store Permissions, I guest not. Or is it here just about the permissions which are assigned to the user/system set on the ECT. I have assigned here BDC Identity, after giving certain permissions on SQL to the account used as Service Account for the Business Data Connectivity Service
  • Is there any chance to save an External List as a Template in order to create it from that template again in different List Libraries again? Or is it required to always create it again and again from the ECT

kind regards,
Dieter

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,434 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,353 questions
{count} votes

Accepted answer
  1. answered 2021-04-13T11:03:52.317+00:00
    Echo Du_MSFT 16,836 Reputation points

    Hi @Dieter Tontsch ,

    You need to give user "Execute" permission to view the contents of the external list. More information, please refer to this articel.

    87414-permissions.png

    Steps:

    1) Sign in SharePoint Central Administration >> click Manage service applications >> select the Business Data Connectivity (BDC) Service and click Manage

    87404-1.png

    2) On the Manage page, check the external content type and click Set Object Permissions >> type user and grant permissions

    87317-2.png

    By design, you cannot save the external list as a template.

    87405-5.png

    Thanks,
    Echo Du

    ======================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

0 additional answers

Sort by: Most helpful