Ideas for free


Change ‘already added’ user information in Sharepoint

Posted in Microsoft Sharepoint by cakriwut on 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!

About these ads

4 Responses to 'Change ‘already added’ user information in Sharepoint'

Subscribe to comments with RSS or TrackBack to 'Change ‘already added’ user information in Sharepoint'.

  1. Steve Savage said,

    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 said,

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

  3. Please help me to Edit UserProfile said,

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

    please help me! thank you.

  4. anonymous said,

    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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: