Reverting shared user tables

If you need to revert shared user tables to reside again on the individual sites in the intranet, follow these steps:

  1. Log in to the master site.
  2. On the Intranet Shared User Tables form, select this site's intranet.

    Two lists of tables display:

    • The top grid lists the currently shared user tables. You cannot edit this list.
    • The bottom grid lists tables that contain a column whose base domain is UserNames.UserId or GroupNames.GroupId. When you set up per site user tables (that is, revert shared user tables), this bottom grid is ignored during processing. All UserNames and GroupNames data are copied to the non-master sites as-is. All UserId and GroupId values remain the same.
  3. Select Set up per site user tables to clear the Shared check box for all tables in the top grid and the Update Referenced ID for all tables in the bottom grid.
  4. Click Process to drop the views at the non-master sites, create the tables and triggers at the non-master sites, copy information from the master site to the tables at the other sites, and regenerate the replication triggers for all sites. (Dropping the views and creating the tables does not occur in a non-master site that is in the same application database as the master site.)

    If you have many sites on this intranet or many users and groups, processing may take a while. The Processing Step area displays the system's progress.

    During processing, the system validates link setup between the master site and the using sites of an intranet. If it finds a problem, an error message displays and nothing is processed; fix the link and then click Process again.

    The Processed field indicates which tables have been processed. After a row on the form is marked as Processed, subsequent "Process" runs do not reprocess that row.

    The Status field indicates that the user tables are not shared.

  5. After processing is complete, you must reapply a valid license document on the master site.
Related topics