HP 3000 Manuals

IMAGE/SQL Administration Guide

Task 6:Updating Information about IMAGE/SQL Users 

This task describes how to update IMAGE/SQL 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 want to check the current users before adding new IMAGE/SQL 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 
[REV BEG]

Use the UPDATE USER command to change the user password, user class, or
DBOPEN mode associated with an IMAGE/SQL user.[REV END]

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

            
[REV BEG]

Here, SMITH.ATC has DBOPEN mode 5 access to the database.  Note that
because the PASS or CLASS parameter was not specified, the user class
does not change.[REV END]

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 SQL syntax User@Account (or User.Account) is used to add an
       IMAGE/SQL user.  This name, referred to as the DBEUserID, is made
       up of an MPE/iX user and account name, connected with the @ symbol
       (or period).  It must contain valid logon syntax.[REV BEG]

   *   The PASS= or CLASS= parameter of the UPDATE USER command is used
       to change the password or class associated with the IMAGE/SQL
       user.  The password or class specified must exist in the
       TurboIMAGE/XL database schema.[REV END]

MPE/iX 5.5 Documentation