Intranet Shared User Tables

Use this form to set up the sharing of user tables so that you can maintain all users and user permissions from the master site for an intranet. All other sites on the intranet have SQL views into the master site's user tables, and they can add, update, and delete records through the views.

You must set up other areas of the application before you can set up shared user tables. See Setting Up a Master Site and Shared Tables for the steps to take.

You can also use this form to revert sharing, so that shared user tables are recreated at the individual sites. See Unsharing Multi-Site Shared Tables.

Notes:

Displaying the Lists of Tables

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.

Select the intranet for the site you are logged into. If a master site has been declared, 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.

About the Tables in the Grids

When you select Set up shared user tables, all of the user tables in the top grid are selected for sharing. The Select check box is read-only for most of the listed tables; with the exception of AccountAuthorizations_mst and UserGroupMap_mst, you must share all of these tables or none of them. These tables let you maintain user information, 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 application-specific tables that include references to user ID or group ID columns that are maintained in one of the user tables. 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.

Processing

Click Process to perform the processing. The Processing Step area informs you of the progress. When a table has been processed, the Processed check box is selected. When processing is complete, the Status field tells you whether the user tables are shared or not shared.


Related Topics

Setting Up a Master Site and Shared Tables

Unsharing Multi-Site Shared Tables

Intranets