Process Button
On the Intranet Shared User Tables form, click this button to process any unprocessed tables that are listed on this form.
This button is enabled if there are any user table records on sites on this intranet that are not set to Processed.
When you are setting up Shared User Tables, this processing occurs when you click
:- Validates links between sites on this intranet, to be sure that they are all set up as linked sites. Displays any errors.
- For each non-master site in the master site's intranet:
- Copies specific user information from each site to the master site.
- Updates data to point to new user and group IDs as necessary.
- Removes the shared user tables from the non-master sites in the intranet and set up SQL views from those sites into the master site.
- Regenerates the replication triggers at the non-master sites in the intranet.
- Regenerates the replication triggers at the master site.
When you are reverting shared user tables, that is, setting up per-site tables, this processing occurs when you click
:- Validates links between sites on this intranet, to be sure that they are all set up as linked sites. Displays any errors.
- Deletes the views into the selected user table from the non-master sites on the intranet.
- Creates the user tables and associated triggers at the non-master sites.
- Copies the data from the master site back to each of the non-master sites. For the UserNames table, the system copies User ID values into the non-master site's UserNames table as-is, so that other records that reference the user IDs do not need to be adjusted.
- Regenerates the replication triggers at the non-master sites.
- Regenerates the replication triggers at the master site.