1. Security Administration Guide
  2. Creating a Separate Security Server Data Source

Creating a Separate Security Server Data Source

If you have multiple Enterprise Servers sharing the same F98OWSEC table and you are not updating all of them to Tools 9.1 Update 3, create two Security Server data sources:

  • One for Enterprise Servers on Tools 9.1 Update 3 (and above).

  • One for Enterprise Servers on releases below Tools 9.1 Update 3.

Note: If you are not using multiple Enterprise Servers (including multiple foundation) that share the same F98OWSEC table on different EnterpriseOne Tools releases, your existing data source is sufficient.

Configuring these data sources helps avoid data conflicts due to overlap between new and old Enterprise Servers.

The following task describes how to copy security tables to a new data source. These tables are used as a secondary location to support the one-way hash encryption.

Complete the following steps BEFORE installing the EnterpriseOne Tools Release.

Caution: Do not create any OCM mappings (client or server) that point to the newly created data source. Doing so will result in system errors.

To copy security tables to a new data source:

  1. Log on to the Deployment Server in the appropriate environment.

  2. Create a new data source.

  3. Open OMW and copy all the tables in the Security data source to the new data source.

The new client and server data source must contain a copy of the following tables from the System-910 or System-900 data source: F0092, F00921, F00927, F0093, F00941, F9312, F98OWPU, and F98OWSEC. See "Understanding and Setting Up Data Sources" in the JD Edwards EnterpriseOne Tools System Administration Guide for instructions on how to use the Data Sources application (P986115) to create a new client and server data source.

For each EnterpriseOne Enterprise Server on Tools release 9.1.3.0 or above, set the DataSource setting in the SECURITY settings to the new client and server data source.

For each EnterpriseOne Enterprise Server on Tools release prior to 9.1.3.0, set the DataSource setting in the SECURITY settings to "System - 910" or "System - 900".

See also: "Copying Tables" in the JD Edwards EnterpriseOne Tools Table Design Guide for more information about using the Object Management Workbench and Table Design Aid to copy tables.