SharePoint (MOSS 2007) delete user

Bossman wants to know how to delete a user in Sharepoint. We convinced him that deleting a user is too difficult due to the traces of that user through the system, so now he wants to change the username to all X or something similar. I poked around the DB and found a couple of UserInfo tables, one in the SharePoint_AdminContent_<guid>

db and the other in SharedServices. Is there a better way to change usernames? Am I wrong?

Thank.

+1


source to share


3 answers


The reason you cannot remove users from SharePoint is because users are not stored in SharePoint. Users are stored in their respective membership provider: AD, aspnetsqlmembershipprovider, etc.

The process of removing a user from a SharePoint environment is to first contact the membership provider and remove it there. After you do this, you have a choice.



  • You can keep user artifacts for outdated information. That is, Joe Blow created the document, and although Joe Blow no longer exists (hit the bus), it's good to know that he created the document.
  • Alternatively, you can run the stsadm -o deleteuser

    Alex command mentioned (once per site), which should disconnect this user from all their artifacts for that site collection. Any documents created by the user will now be owned by the sysadmin (I believe). An example of using this option is when a user account was misspelled and you want to delete all traces before creating the correct account.
0


source


Please do not access the database directly as it is not supported; you can even destroy integrity in the process.

If you really want to "" remove "all traces of a user, I suggest you stsadm -o migrateuser

rename the user to a dummy XXX user created in your membership provider.



Edit : this is migrateuser and not renameuser, my mistake

http://technet.microsoft.com/en-us/library/cc262141.aspx

+2


source


There is a " stsadm -o deleteuser

". See this TechNet article . This command will remove the user from the site collection.

You can also find more options on Keith Richie's blog . That is, from the era of WSS 2.0 / SPS 2003, but there is a lot of good information there.

+2


source







All Articles