In this article we can explore a new command associated with Squadron > Explorer add-in.
What is Ensure User?
Ensure User is the command that invokes EnsureUser() method for the SPWeb objects specified.
Why we need to call it?
For each new user in a web site, a user record is added to the User Info table. For new SharePoint installations, when the users login to the site first time, there will be simultaneous addition of records to the above table & might result in SQL Server Throttling error.
A wise advice for the problem is to add the user explicitly to each web site before the opening SharePoint to public.
Squadron is a Free SharePoint Administration tool available at www.sharepointcto.com.
How to perform Ensure User?
Please download & Install the latest version of Squadron. After executing it in Farm Account mode you will receive the following screen.
Enter the URL in the top pane & click the Explorer item from left pane. In the appearing SharePoint Web Application view, select you web item.
Click on the Ensure User button visible in the screen. In the appearing dialog enter the user names in the format DOMAINUser:
After entering the user names, click the Execute button in the bottom to continue. You will get the following message box after operation is completed.
This makes sure that the user is available in the UserInfo table for the particular web site. This will prevent the possible SQL Server Errors happening in SharePoint Installations with hundreds of users.
You can also invoke the Ensure User within the Web Application & Site Collection level. The same button will be enabled for those commands.
For Web Application item selection:
For Site Collection item selection:
On invoking the Ensure User command, all the Web items will be enumerated in the selection dialog. You can select the web items to be processed for.
Following is the code that performs the EnsureUser() method invoking.
In this article we have explore the Ensure User command. There are more commands associated with the Explorer Add-in of Squadron – plus, they are context sensitive based on Site / Web / List / Item types.