Change ‘already added’ user information in Sharepoint


(This articles has already been posted in Now I post it again in my own blog.)

For administrators who wants to add new users into a SharePoint site, SharePoint has a great interface that lets you read user details from the ActiveDirectory / domain information database. Unfortunately, changing user information in the ActiveDirectory / domain won’t automatically reflect in the SharePoint user information databases. We cannot overturn a user’s registration and re-register to get the changes saved because SharePoint will prefer old information rather then reading new information from the ActiveDirectory / Domain.

Let’s See the Problem

As an example, an administrator adds a new user JohnDoe to the SharePoint site, and when you click “next,” SharePoint will contact ActiveDirectory to check if the user exists. If the user exists then it will retrieve its information and fill in Email and Display Name information.


After a successful addition, you can have full information of the new user as well as context menu to send email, add to address book etc.


At this point, you won’t have any problems and everything appears to work properly. Now, the user “None” is coming to you , and he doesn’t like his “None” nick. He wants to make it “Anonymous” instead.
As an Administrator, you will go through ActiveDirectory Users management console and change “None” to “Anonymous”.

But When You Look at SharePoint, it does not change….

SharePoint has a separate table to manage user information (the “UserInfo” table in the SharePoint site information.) That’s why, updating in ActiveDirectory user’s information won’t be reflected in SharePoint.


Un-register and re-registering user to SharePoint

Un-registering a user from SharePoint is a good idea, but SharePoint is stepping ahead. SharePoint will not delete user information but will only inactivate it ! Kind of insane? No, because SharePoint will make sure that every single object in its database has the correct parent that is the Users!
And believe me, un-register and re-registering “JohnDoe” will only cycle back to “JohnDoe”. This is because, SharePoint will refer to it’s databases rather than external database. It will look for information in its databases first, before searching other media.
You also don’t have any interface to edit userInformation.


SQL Will Fortunately help Us !

As stated above, SharePoint has its own UserInfo table for managing point to user information. The UserInfo table has fields like “tp_login”, “tp_Title”, “tp_Email” etc. So, don’t bother with SharePoint UI. Get your SQL Analyzer and start to edit directly into this table. The “UserInfo” table exists in “site database”.

Then, the SQL syntax:

update userinfo set tp_title=’Anonymous’ where tp_title=’None’

will sufficiently resolve this problem. And you will see the result promptly.


And good luck!


Riwut Libinuko, experienced Architect. Currently working with Credit Agricole CIB, responsible for SharePoint platform in Asia Pasific. . Certification: SharePoint 2013, SharePoint 2010, SharePoint 2007, ITiL v3

Posted in Microsoft Sharepoint
4 comments on “Change ‘already added’ user information in Sharepoint
  1. Steve Savage says:

    Rather than hacking the database, I think all you need to do is modify the user information for a particular site.

    Just go Site Settings—->Edit User Information

    Find the user and modify the name and email address, or delete it at your option.

  2. Benoit HAMET says:

    Moreover, modifying the SQL databases directly (by using SQL Manager/SQL Query) is not supported by Microsoft

  3. Please help me to Edit UserProfile says:

    I have gone “Site Settings—->Edit User Information” but Email field and any field disappear to Edit.

    please help me! thank you.

  4. anonymous says:

    Use SSP in WSS 3.0. There is a users and profiles selection.

    Once in the website, select to View Profiles. Select any profile, and change any or all information.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: