Change ‘already added’ user information in Sharepoint

By | August 6, 2006

 

English:
(This articles has already been posted in
www.msd2d.com. 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.

Sample01

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.

Sample02

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.

Sample03


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.

Sample04

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.

Sample05

And good luck!

4 thoughts on “Change ‘already added’ user information in Sharepoint

  1. Steve Savage

    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.

    Reply
  2. Benoit HAMET

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

    Reply
  3. Please help me to Edit UserProfile

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

    please help me! thank you.

    Reply
  4. anonymous

    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.

    Reply

Leave a Reply