Synchronizing Users and Groups With the UpdateUsers Utility

If you move users and groups, their identities (SIDs) change, and unless you synchronize their identities between Planning and Shared Services, their assigned access permissions are lost. Situations requiring synchronization:

You can use two utilities in concert to synchronize changes:

  1. Run the UpdateNativeDir utility to update user and group identities in Shared Services.

    UpdateNativeDir and its documentation are in the EPM_ORACLE_INSTANCE/common/utilities/UpdateNativeDir directory.

    For more information on the directory path, see About EPM Oracle Instance.

  2. Run the UpdateUsers.cmd utility to update the SIDs in Planning with the changes in Shared Services.

Note:

It is important to run the utilities in this order.

  To launch the UpdateUsers utility:

  1. At the Command Prompt, from the planning1 directory, enter the command, using this syntax:

    updateusers [-f:passwordFile] serverName adminName applicationName

    For the full path to planning1, see About EPM Oracle Instance.

    Table 23. UpdateUsers Syntax

    Parameter

    Description

    Required?

    [-f:passwordFile]

    Optional: If an encrypted password file is set up, use as the first parameter in the command line to read the password from the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

    No

    serverName

    The server on which the Planning application residesYes
    adminNameThe administrator's name for logging on to the Planning application.Yes

    applicationName

    The Planning application for which to synchronize users and groups (must be on the server on which the utility is run).

    Yes

    /?

    Specified by itself, prints the syntax and options for UpdateUsers.

    No

    For example:

    updateusers.cmd ABCserver admin Planningapp

  2. If prompted, enter your password.

  3. Optional: To view information on the results, open the UpdateUsers.log file in the EPM_ORACLE_INSTANCE/diagnostics/logs/planning directory.