Memberships located in a users personal site are managed for the user automatically by 2 timer jobs that run.
Profile Synchronization (default interval is every 1 hour)
Quick Profile Synchronization (default interval is every 5 minutes)
These schedules can be changed by running the following stsadm command with the "-SyncTiming" (profile sync) and the "-SweepTiming" (quick profile sync) parameters.
stsadm -o sync
{-ExcludeWebApps <web applications> |
-SyncTiming <schedule(M/H/D:value)> |
-SweepTiming <schedule(M/H/D:value)> |
-ListOldDatabases <days> |
-DeleteOldDatabases <days>}
These timer jobs synchronize user information tables in every site collections with any updated profile information in the user profile database. They also identify whats sites the user is a member of and store that information for the user in the memberships list on the users personal site.
Being a member of the site was a little vague as to how does sharepoint know. Do I just need to be assigned permissions to the site, be in a special group? The answer is that by default when a site collection is created there is a members sharepoint group created too. This group is assigned as the "members of this site" group. You can create a custom sharepoint group and assign the custom sharepoint group to be the "members of this site" group. This can be done from the people and groups settings, viewing the members of any sharepoint group and selecting "Settings -> Set Up Groups" option in the toolbar.
Also, even though sharepoint groups are managed at the site collection level, each site in the site collection can identify the group that will be considered "members of this site" group. So when the timer job checks out the groups for memberships it will look at each site in the farm to determine the sharepoint group to use and then update each users membership with that information.
Keep in mind that if the user is also using Office 2007 their memberships show up as "My SharePoint Sites" in the open and save dialogs. From what I am lead to understand is the information that renders under this section of your office client application is updated upon the first time an office application is started for the day.
This information also shows up in the users "My Links - My SharePoint Sites" dropdown in the top right of a sharepoint site.
This is a MOSS only feature and is available with MOSS Standard and Enterprise editions.