Sharing User Tables

After you have set up the sites on an intranet and assigned a master site to the intranet, you can share user tables.

For more information, see Setting Up a Master Site and Shared Tables.

Note:

Set up or revert the tables on this form ONLY when no other users are logged into any of the sites where changes will occur.
See Intranet Licensing.
You must set up intranet licensing at the master site and at all participating sites before you set up intranet shared user tables.
User sessions are still managed at individual sites.

Log in to the master site.
On the Intranet Shared User Tables form, select this site's intranet.
In order to make changes using this form, you must be logged into the selected intranet's master site. You can view, but not change, the shared tables information on this form from other sites on the intranet if the master site is replicating the Site Admin category to the other sites.

If a master site has been declared for this site's intranet, the system displays the master site name and a list of the user maintenance tables that can be shared. Not every user maintenance table is listed here, because some tables are not available for sharing.

If no master site has been declared for the selected intranet, the rest of the form is blank and you cannot continue.

Two lists of tables are shown:
- The top grid lists user tables that can be shared. You cannot edit this list. When you select Set up shared user tables, all of the user tables in the top grid are selected for sharing. You can clear the Shared option for some tables, but not all of them, as described below.
  The user tables let you maintain user information, which can include application-specific information such as initials, employee, or multi-site group, user groups, user/group assignments, user/group authorizations, and user/license module assignments.
  
  For more information about how sharing of these tables is handled in multiple sites per database vs. one site per database environments, see Setting Up a Master Site and Shared Tables.
- The bottom grid lists tables that contain a column whose base domain is UserNames.UserId or GroupNames.GroupId. The bottom grid is used during the setup of shared user tables to identify the tables and columns that might need to be updated if records that were formerly defined in the Usernames or Groupnames tables in the non-master site are moved to the master site, but with different UserId or GroupId values.
  When you select Set up Shared User Tables, the Update Referenced ID check box for each of these associated tables is selected. This grid is display-only for standard application tables. You can add custom tables that include user or group references at the end of this grid. When the user tables are shared or unshared, the references in the associated tables are updated appropriately.
If you have custom tables that contain a column whose value comes from base domain UserNames.UserId or GroupNames.GroupId, add your custom table and its associated ID column to the Non-Shareable Tables grid. We recommend that your custom tables refer to the Username or Groupname columns, rather than the ID columns, because the distinct list of Usernames and Groupnames across intranet sites is always the same, whether they are stored in shared tables or per site, and therefore no changes are required for data referencing this base domain.
Select Set up shared user tables, which automatically selects Shared for all tables in the top grid and Update Referenced ID for all tables in the bottom grid.

In the top grid, clear the Shared check box for any tables that you do not want to share between sites.

Note: Be aware of how this works. For the Usernames, GroupNames, UserEmail, UserModules, UserPasswordHistory, UserCalendar, and UserTask tables:

Table names	Select Shared on Intranet Shared User Tables?	Result for one site per database	Result for multiple sites per database
Usernames, GroupNames, UserEmail, UserModules, UserPasswordHistory, UserCalendar, and UserTask	No	Tables are not shared across multiple sites.	Tables are shared for multiple sites within a database, but not across different databases.
Usernames, GroupNames, UserEmail, UserModules, UserPasswordHistory, UserCalendar, and UserTask	Yes	Tables are shared across multiple sites.	Tables are shared across multiple sites and databases.
AccountAuthorizations_mst, user_local_mst, and UserGroupMap_mst	No	Tables are not shared across multiple sites.	Tables are not shared across multiple sites.
AccountAuthorizations_mst, user_local_mst, and UserGroupMap_mst	Yes. You can select each of these tables individually for sharing.	Tables are shared across multiple sites and databases.	Tables are shared across multiple sites and databases.

Click Process to copy information from the tables at the other sites to the master site's table, delete the table from the other sites (creating views into the master site tables instead), and regenerate the replication triggers for the other sites. (Removing tables and setting up views does not happen if the non-master site is in the same application database as the master site.)

If you have many sites on this intranet or many users and groups, processing can take a while. The Processing Step area shows 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. If tables are shared, they are now resident only in the master site's database. After a row on the form is marked as Processed, subsequent "Process" runs will not reprocess that row.

The Status field indicates whether the user tables are shared or not shared.

After processing all the tables and sites, the system regenerates the replication triggers at the master site.
After processing is complete, you must reapply a valid license document on the master site.

Note: When you are already sharing user tables, and you add a new site to the current master site's intranet, you might also want to set up the new site to share user tables. To do this:

In the Intranet Shared User Tables form, select Set up per site user tables and click Change Setup Option to change the field label to Set up shared user tables.
Click Process. The status of the shared tables is checked as each site is processed. If sharing has already been set up for a site, no processing occurs for that site, and the process continues with the next site. When it encounters a site that is not already set up, the site is processed.