HP 3000 Manuals

Updating Information about Turbo CONNECT Users: Task 6 [ ALLBASE/Turbo CONNECT Administrator's Guide ] MPE/iX 5.0 Documentation


ALLBASE/Turbo CONNECT Administrator's Guide

Updating Information about Turbo CONNECT Users:  Task 6 

This task describes how to update Turbo CONNECT user information.

Getting Ready 

To perform this task, you must be both the TurboIMAGE/XL DBC and a DBA of
the attached DBEnvironment.

If you wish to check the current users before adding new Turbo CONNECT
users, issue the DISPLAY USER command.  For example:
________________________________________________________________
|                                                              |
|     >>DISPLAY USER                                           |
|                                                              |
|     TurboIMAGE/XL DB : SALES.SERED.ATC                       |
|     DBEnvironment    : PARTSDBE.SERED.ATC                    |
|                                                              |
|     USER LOGON         DBOPEN MODE  USER PASSWORD  USER CLASS|
|     ----------         -----------  -------------  ----------|
|                                                              |
|     NANCY@ATC          5            ;              64        |
|     SMITH@ATC          6            CLERK          14        |
|                                                              |
|     >>                                                       |
________________________________________________________________

Performing the Task 

Use the UPDATE USER command to change the user password or DBOPEN mode
associated with a Turbo CONNECT user.

For example:
________________________________________
|                                      |
|     >>UPDATE USER SMITH@ATC TO MODE=5|
|     >>                               |
________________________________________

Here, SMITH@ATC has DBOPEN mode 5 access to the database (see Task 
Reference).  Note that because the PASS parameter was not specified, the
user class does not change.

The DISPLAY USER command now reflects the updated information:
________________________________________________________________
|                                                              |
|     >>DISPLAY USER                                           |
|                                                              |
|     TurboIMAGE/XL DB : SALES.SERED.ATC                       |
|     DBEnvironment    : PARTSDBE.SERED.ATC                    |
|                                                              |
|     USER LOGON         DBOPEN MODE  USER PASSWORD  USER CLASS|
|     ----------         -----------  -------------  ----------|
|                                                              |
|     NANCY@ATC          5            ;              64        |
|     SMITH@ATC          5            CLERK          14        |
|                                                              |
|     >>                                                       |
________________________________________________________________

Task Reference 

 *  The ALLBASE/SQL syntax, User@Account, is used to add a Turbo CONNECT
    user.  This name, referred to as the DBEUserID, is made up of an MPE
    XL user and account name, connected with the @ symbol.  It must
    contain valid logon syntax.

 *  The PASS= parameter of the UPDATE USER command is used to change the
    password associated with the Turbo CONNECT user.  The password
    specified must exist in the TurboIMAGE/XL database schema.

 *  Because Turbo CONNECT provides read-only access, it supports DBOPEN
    modes 5, 6, 7, and 8.  Refer to the TurboIMAGE/XL Database Management 
    System Reference Manual for more information about these DBOPEN
    modes.



MPE/iX 5.0 Documentation