Set Permissions to External Content Type: Once you have created an External Content Type using the SharePoint Designer or Visual Studio 2010, you may try to access that to display the data in SharePoint using an External List. At that time you may encounter "Access denied by Business Data Connectivity". The reason is that External List requires that External Content Type and External Content Type are using Business Data Connectivity services proxy to access an External Data Source. With the same principle of BDC in MOSS 2007-users are required to have BDC object permission before they can use it. So we need to set the permissions to the External Content Type.
1. Go to Central Administration -> Application Management -> Manage Service Applications
Powershell script:
#----------------------------------Input Parameters --------------------------- $userId="domainName\UserName" $serviceContextURL="http://serverName:8080/" $ECTName="ECT" $ECTNamespace="http://demo2010a:5000" [String[]]$permissions=@("Execute","Edit","SelectableInClients","SetPermissions") #--------------Set Permissions to External Content Type---------------- $ECT = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "Entity" -ServiceContext $serviceContextURL -Name $ECTName -Namespace $ECTNamespace if($ECT -ne $null) { $user = New-SPClaimsPrincipal -Identity $userId -IdentityType WindowsSamAccountName Grant-SPBusinessDataCatalogMetadataObject -Identity $ECT -Principal $user -Right $permissions } else { write-host -f Yellow $ECTName external content type does not exists }
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: