Refresh Security Extracts

How to:

This process creates security extract files that are stored as FOCUS files in the JOWSEC application that is created when you configure the adapter.

You must repeat this step whenever security extract information needs to be updated.


Top of page

x
Procedure: How to Refresh Security Extracts on Windows

From the Adapters list in the navigation pane or the Adapters folder of the DMC:

  1. Right-click the configured JD Edwards EnterpriseOne adapter.
  2. Select Refresh Security Extracts.

    The Refresh Security Extracts pane opens, indicating the Security mode you selected during adapter configuration: ROLE-based or GROUP-based (see Configuration Parameters and Tasks for JD Edwards EnterpriseOne). Note that the required JDE tables that are listed in the first column vary depending on the Security mode that is in effect.

  3. For each table, select the suffix of a previously configured DBMS from the drop-down list.

    Note: The listed tables may be associated with different DBMSs.

  4. In the Qualifier input boxes enter the qualifier associated with each table, using the syntax required for the selected DBMS:
    • For SQLMSS: [database.]owner
    • For DB2: [location.]owner
    • For SQLORA: owner
  5. In the Connection input boxes, enter the same connection name you used when configuring the selected DBMS.
  6. Click Submit.

    The refresh occurs transparently. A message indicates the process was successful.


Top of page

x
Procedure: How to Refresh Security Extracts on IBM i

From the Adapters list in the navigation pane or the Adapters folder of the DMC:

  1. Right-click the configured JD Edwards EnterpriseOne adapter.
  2. Select Refresh Security Extracts.

    The Refresh Security Extracts pane opens, indicating the Security mode you selected during adapter configuration: ROLE-based or GROUP-based (see Configuration Parameters and Tasks for JD Edwards EnterpriseOne).

    The JDE tables required for this procedure are listed. Note that the list varies depending on the Security mode that is in effect.

  3. In the input boxes provided, enter a library name for each of the JDE tables.
  4. Click Submit.

    The refresh occurs transparently. A message indicates that the process has been successful.


WebFOCUS