.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Grant permission to BCS External entities via PowerShell

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint


We're using an assembly connector with BCS. When the solution is deployed, we have to manually grant permissions to the entities by going to Central Administration -> Manage Service Applications -> Business Connectivity Services -> then select our entities and grant permissions.

I'm looking for ways to automate this - can someone please give me some pointers?


View Complete Post

More Related Resource Links

The condition of creating assembly for external access permission?

To create an EXTERNAL_ACCESS or UNSAFE assembly in SQL Server, one of the following two conditions must be met: 1. The assembly is strong name signed or Authenticode signed with a certificate. This strong name (or certificate) is created inside SQL Server as an asymmetric key (or certificate), and has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission (for external access assemblies) or UNSAFE ASSEMBLY permission (for unsafe assemblies). 2. The database owner (DBO) has EXTERNAL ACCESS ASSEMBLY (for EXTERNAL ACCESS assemblies) or UNSAFE ASSEMBLY (for UNSAFE assemblies) permission, and the database has the TRUSTWORTHY Database Property set to ON. The two conditions listed above are also checked at assembly load time (which includes execution). At least one of the conditions must be met in order to load the assembly. This is a explanation on msdn.I think if only one of these condition is met,it will work. But after I do the first condition,I still can not create an assembly with EXTERNAL_ACCESS permission except SET TRUSTWORTHY on. should the two condition be met?  

Webpart and AddPSSnapin - grant permission

Hello, I'm developing webpart, that will give some users option to create mailboxes in Exchange 2007. I have two machines in use (third - DC): 1) Windows 2003 R2 x86, MOSS 2007 SP1, Windows Powershell 1.0, Exchange 2007 Management Tools 1) Windows 2003 R2 x86, Exchange 2007, Windows Powershell 1.0 On my MOSS machine I maded two applications - webpart and console application. MOSS (app pool) is working on domain admin account. Console application I'm running on the same account. Both are using the same code with modified parameters: public static void CreateUserMailbox(string domain, string ou, string database, string alias, string name, string displayName, SecureString password) { string upn = string.Format("{0}@{1}", alias, domain); ICollection<PSObject> results; // Create a runspace. We can't use the RunspaceInvoke class this time // because we need to get at the underlying runspace to explicitly // add the commands. RunspaceConfiguration rc = RunspaceConfiguration.Create(); PSSnapInException snapEx = null; PSSnapInInfo info = rc.AddPSSnapIn("Microsoft.Exchange.Management.PowerShell.Admin", out snapEx); Runspace myRunSpace = RunspaceFactory.CreateRunspace(rc); myRunSpace.Open(); // Create a pipeline... Pipeline pipeLine = myRunSpace.CreatePipeline(); using (pipeLine) { /

error: "The application-specific permission settings do not grant Local Activation "

Log Name:      System Source:        Microsoft-Windows-DistributedCOM Date:          9/14/2010 11:55:35 AM Event ID:      10016 Task Category: None Level:         Error Keywords:      Classic User:         XXXXX\spadm Computer:      XXXX.XXXXX.com Description: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1}  and APPID {61738644-F196-11D0-9953-00C04FD919C1}  to the user XXXXX\spadm SID (S-1-5-21-6236335-3733969977-3477648964-5701) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool. Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">   <System>     <Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />     <EventID Qualifiers="49152">10016</EventID>     <Version>0</Version>  &nb

GRANT permission on schema to user in SQL 2000

Hi,I am using following statement to grant specified permissions on schema to a user in SQL Server 2005. GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE on ::[Schema Name] to [My DB User]I need to perform the same in SQL 2000. However, this does not work in SQL Server 2000. Is there any equivalent syntax which can be used in both (SQL 2000 & 2005).Thanks in advance...

"Failed to grant minimum permission requests" when building release mode dll

Hi there,I have started to receive a  release mode build failure for which I  would appreciate some advice. The build works fine in debug but sgen fails in release when a dll that contains a web-reference is linking to a c++\cli dll on the network. The debug build links to the same (release mode) c++\cli dll without this problem.I believe this has started since adding the web-reference. Any idea what the work around is?Many thanks.Duncan4>C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\bin\sgen.exe /assembly:"C:\Projects\Forecaster\Source 2.0\GH.Forecaster.IO\obj\Release\GH.Forecaster.IO.dll" /proxytypes /reference:S:\SoftwareUtils\Release\GH.Common\Release\Latest\GH.Common.Unmanaged.dll /reference:S:\SoftwareUtils\Release\GH.Common\Release\Latest\GH.Common.Util.dll /reference:"C:\Projects\Forecaster\Source 2.0\Release\GH.Forecaster.Data.dll" /reference:"C:\Projects\Forecaster\Source 2.0\Release\GH.Forecaster.Util.dll" /reference:S:\External\log4net-1.2.10\bin\net\2.0\release\log4net.dll /reference:"C:\Program Files\NUnit-Net-2.0 2.2.8\bin\nunit.framework.dll" /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.EnterpriseServices.dll /reference:C:\WINDOWS\Microsoft.NET\Framework\v2

Execute permission denied on with the grant and with grant permission enabled. HELP PLEASE. Grantin


Here is the code that Im running.  The user Tester has the both Grant and With Grant checked.

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'AAAtestOW')


DROP Procedure dbo.AAAtestOW



CREATE Procedure dbo.AAAtestOW





If i add the grant execute command for me I get
"Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself."

If I try

Can't find a link about Grant permission programmatically


Hi guys,


two weeks ago I read a MSDN(?) article how to grant/revoke permission for some users/roles/groups on a specific page or holder temporarily or with condion. The article shows how to do it Form_Load() in c#. But I can't find the link with googling or in MSDN library.

Please let me know if you know the url?

What I want to do is:

There is a folder called employeePDFs.

The folder will have 1000s employees' sub folder ({lastname}{firstname}{employeeID}). Each folder will have very personal indivual PDF files which are manually uploaded.

If an employee logs on, then the logon employee can view a page which has a list of PDF files in his own folder only.

Those PDF files can be assessed only by the user.

or better solution?




SP installed in DomainA, how to grant permission for users in DomainB ?



SP Foundation 2010 installed in Win2008R2 as Single Server Farm. It is located in DomainA. Users logged on into DomainB are denied access. I would like to add these DomainB users into the page permission. But the GUI seems not to be able to resolve anything outside of its DomainA. Outside of Sharepoint, the DomainA trust DomainB. I can log into a DomainA computer using my DomainB account.

Question : is it possible for Sharepoint to accept users from multiple domains? If yes, can you please hint me the solution or documentation?

Thanks in advance


Grant Unique Permission to columns


In SharePoint; How can I grant edit permission to a column to a list of people and to the same column grant veiw only to another list of people?

SQL Server 2005 Grant User Permission to Create Stored Procedure and Grant Execute Access to another


I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.

We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.

Grant Create Stored Procedure to user1 on a specific database

Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.


Powershell script to create permission levels & groups and add users


We are trying to setup a Powershell script to create permission levels & groups and add users to groups for a SharePoint site.

We've tried to use the new
PowerShell commandlet for 2010 but it will not add a user to a group unless the user is already defined to the SharePoint site.

Does anyone know how to do this without having to add the users to the site first - or if it can be done - in SP 2010 ?

Thank you..

My profile -- grant permission to other to edit the information



I would like to know if one can grant permission to another person to edit "My Profile" or "My Site"? That is certain people will be able to edit my profile and do various things as if the person iteself.

Thanks in advance.


ASP.NET 4.0 Dynamic Data and Many to Many Entity Framework Entities

I did not play much with Dynamic Data controls in VS2008 and just made a cool discovery in VS2010 Beta 2. This may not even be new, but as I'm sitting 30,000+ feet over the Atlantic ocean, I don't have access to VS2008 at the moment to check.

System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm


Good Day all,

Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. 

What do you think my approach should be. 

I already have read rights to IIS user to my BIN folder. 

Thanks for the help. 

Handling external C++ exceptions


Hi. I'm working in a application that uses an external .Dll developed in C++ language. According the business rule, the .Dll can throws one exception if it found a error. My question is if it's possible handle or catch a exception throwed by the C++ dll? The try/catch doesn't works. Bellow there's the code I'm using to call the C++ dll.

        public extern static IntPtr LoadLibrary(string lpLibFileName);

        [DllImport("kernel32", CharSet = CharSet.Ansi)]
        public extern static IntPtr GetProcAddress(IntPtr hLibModule, string procName);

        public extern static bool FreeLibrary(IntPtr hLibModule);

        private delegate void DllMethodCallBack(string param1, string param2);

        public void CallDllMethod(string param1, string param2)

Test Run: Request/Response Testing with Windows PowerShell


Did you know you can use Windows PowerShell to perform lightweight request/response testing for an ASP.NET Web app? Here's how.

Dr. James McCaffrey

MSDN Magazine May 2008

Test Run: Web UI Automation with Windows PowerShell


Here we show you how to use Windows PowerShell to create quick and easy UI test automation for ASP.NET and classic ASP Web applications.

Dr. James McCaffrey

MSDN Magazine March 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend