SharePoint External List Permissions

%3CLINGO-SUB%20id%3D%22lingo-sub-1584992%22%20slang%3D%22en-US%22%3ESharePoint%20External%20List%20Permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584992%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20an%20External%20List%20on%20Sharepoint%20that%20gets%20data%20from%20SQL%20server.%26nbsp%3B%20On%20My%20account%20I%20can%20see%20the%20list%20data%20and%20everything%20works%20ok.%26nbsp%3B%20I%20want%20to%20grant%20access%20to%20a%20group%20of%20users%20(Basically%20the%20whole%20team)%26nbsp%3B%20I%20added%20the%20whole%20team%20to%20the%20sharepoint%20site%20and%20everyone%20can%20access%20it%20ok.%26nbsp%3B%20However%20when%20they%20go%20to%20the%20list%20with%20External%20conetent%20I%20get%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccess%20denied%20by%20Business%20Data%20Connectivity.%3C%2FP%3E%3CP%3ECorrelation%20ID%3Add5d6f9f-2054-a000-87b8-8c3592d584a7%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20did%20to%20try%20to%20fix%3A%3C%2FP%3E%3CP%3EI%20updated%20the%20BCS%20External%20content%20type%20permissions%20to%20include%20the%20group%20(Sharepoint%20Admin%20%26gt%3B%20BCS).%26nbsp%3B%20Currently%20I%20gave%20them%20all%20the%20permissions%20(Edit%2C%20Execute%2C%20Selectable%20in%20Clients%2C%20Edit%20Permissions).%26nbsp%3B%20I%20also%20set%20MetaData%20Store%20permissions%20to%20also%20include%20this%20group.%26nbsp%3B%20There%20I%20also%20gave%20them%20all%20permissions%20like%20above.%26nbsp%3B%20I%20have%20made%20these%20changes%20over%2024%20hours%20ago%20and%20none%20of%20the%20users%20can%20access%20the%20list.%26nbsp%3B%20They%20all%20get%20the%20same%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20missing%3F%26nbsp%3B%20Any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%20Office%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589136%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20External%20List%20Permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589136%22%20slang%3D%22en-US%22%3E%3CP%3EFigured%20it%20out...%20The%20group%20that%20I%20used%20was%20a%20group%20that%20was%20already%20created%20by%20the%20company%20and%20I%20did%20not%20notice%20that%20the%20group%20was%20an%20%22Office%20365%22%20group%20and%20not%20a%20%22Security%20Group%22.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I created an External List on Sharepoint that gets data from SQL server.  On My account I can see the list data and everything works ok.  I want to grant access to a group of users (Basically the whole team)  I added the whole team to the sharepoint site and everyone can access it ok.  However when they go to the list with External conetent I get:

 

Access denied by Business Data Connectivity.

Correlation ID:dd5d6f9f-2054-a000-87b8-8c3592d584a7

 

What I did to try to fix:

I updated the BCS External content type permissions to include the group (Sharepoint Admin > BCS).  Currently I gave them all the permissions (Edit, Execute, Selectable in Clients, Edit Permissions).  I also set MetaData Store permissions to also include this group.  There I also gave them all permissions like above.  I have made these changes over 24 hours ago and none of the users can access the list.  They all get the same error. 

 

What am I missing?  Any help would be greatly appreciated.

1 Reply

Figured it out... The group that I used was a group that was already created by the company and I did not notice that the group was an "Office 365" group and not a "Security Group".