Reader Level:

Squadron Ensure User Command

By Jean Paul on Apr 09, 2013
In this article we can explore a new command associated with Squadron > Explorer add-in.

In this article we can explore a new command associated with Squadron; the Explorer add-in.

What is Ensure User?

Ensure User is the command that invokes the 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 the first time, there will be simultaneous addition of records to the table that might result in a SQL Server Throttling error.

The wise advice for the problem is to add the user explicitly to each web site before opening SharePoint to public.


Squadron is a Free SharePoint Administration tool available at


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 the left pane. In the SharePoint Web Application view that appears, select your web item.


Click on the "Ensure User" button visible in the screen. In the dialog that appears enter the user names in the format DOMAIN\User:


After entering the user names, click the "Execute" button in the bottom to continue. You will get the following message box after the operation is completed.


This ensures 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.




In this article we have explored 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.

Jean Paul
Jean Paul

Jean Paul is a Developer plus Architect working on Microsoft Technologies for the past 12 years. He is very much passionate in programming and his core skills are SharePoint, ASP.NET & C#.  In the academic side ... Read more

Personal Blog:



JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.

Trending up

Infragistics jQuery Controls