Server Authentication with Remote User IDs

DB-Gate can employ Server Authentication Entries to authenticate connections to servers automatically, without entering the logon values each time.

To set up Server Authentication Entries, select 21. Work with Server Authentication from the DB-Gate main menu (STRDB). The Work with Server Authentication Entries screen appears:

​                   ​ Work with Server Authentication Entries​                                                                 ​ Subset by user . . . .​ ​           ​   ​ Type options, press Enter.               ​           ​ server . . .​ ​           ​     ​ 1=Select​  ​ 4=Remove​                               ​ remote user.​ ​           ​                                                                                    ​ Opt​ ​ User ​      ​ Server​                    ​ Remote user​             ​ Password​   ​ ​  ​  ​ AMIR      ​ ​ LO                       ​ ​ AMIR                     ​ ​ *YES​      ​  ​  ​ AMIR      ​ ​ MS                       ​ ​ SASHA                    ​ ​ *YES​      ​  ​  ​ AMIR      ​ ​ MY                       ​ ​ SASHA                    ​ ​ *YES​      ​  ​  ​ AMIR      ​ ​ ORA                      ​ ​ HR                       ​ ​ *YES​      ​  ​  ​ AMIR      ​ ​ TTT                      ​ ​ AMIR                     ​ ​ *YES​      ​  ​  ​ AU        ​ ​ RAZLEE2                  ​ ​ SECURITY2P               ​ ​     ​      ​  ​  ​ AU        ​ ​ RSASECURID               ​ ​ AU                       ​ ​ *YES​      ​  ​  ​ AU        ​ ​ TTT                      ​ ​ QSECOFR                  ​ ​     ​      ​  ​  ​ AV        ​ ​ RDBRL2                   ​ ​ SECURITY2P               ​ ​ *YES​      ​  ​  ​ AV        ​ ​ RSASECURID               ​ ​ AV                       ​ ​     ​      ​  ​  ​ CT        ​ ​ RSASECURID               ​ ​ CT                       ​ ​ *YES​      ​  ​  ​ DB        ​ ​ ARD400                   ​ ​ sale                     ​ ​ *YES​      ​  ​  ​ DB        ​ ​ ARD400LO                 ​ ​ db                       ​ ​ *YES​      ​  ​  ​ DB        ​ ​ A150                     ​ ​ sale                     ​ ​ *YES​                                                                       ​      More...​  ​ F3=Exit    F6=Add New    F12=Cancel            ​                                 ​                                                                                                                                                                  ​

Each line on the body of the screen shows a single entry: when a named User connects to a given Server, the connection uses the indicated Remote user name. If the Password field is set to *YES, the connection also uses a password set on the connection's detailed user authentication entry.

To limit the display to a subset of users, servers, or remote users, enter the first few characters of the value into the corresponding Subset by field at the top right of the screen, and press Enter.

To add a new server authentication entry, press the F6 key. The Add User Authentication Entry​ screen appears, as shown in Adding a New Server Authentication Entry.

To modify a server authentication entry, type 1 in the Opt field for the entry and press Enter. The Modify User Authentication Entry screen appears, as shown in Modifying a Server Authentication Entry.

To remove a server authentication entry, type 3 in the Opt field for the entry and press Enter. The Remove User Authentication Entry screen appears, showing the information for the entry again. Press Enter to confirm the removal or F12 to cancel.