When a new user is added to a SharePoint Website what happens in background, what are the process that runs, which tables in the DB are updated?

  • 4
    This process isn't documented in detail. This is because it's not supported to query of modify SharePoint Databases directly. What are you trying to achieve? I'm sure there's an answer without directly going to the database.
    – MHeld
    Mar 12, 2018 at 12:04

1 Answer 1


When we give a user permission to the site collection, or when that user creates/updates/deletes any item within a Site Collection, the user will be added to the Hidden User information List which store information in relevant content database [WSS_Content].[dbo].[UserInfo] table.

There are two timer jobs named User Profile Service Application - User Profile to SharePoint Full Synchronization and User Profile Service Application - User Profile to SharePoint Full Synchronization, will update the user profile information in the user profile service application to User information list, through a mapping between the Profile DB and content DB UserInfo table.

More information about User Information List, check the article:

User Information List in SharePoint All details

What is Hidden User Information (Userinfo) List in SharePoint 2010/2013

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.