HP 3000 Manuals HP 3000 Manuals
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
Use the UPDATE USER command to change the user password or DBOPEN mode
associated with an IMAGE/SQL user.
For example:
________________________________________
| |
| >>UPDATE USER SMITH@ATC TO MODE=5|
| >> |
________________________________________
Here, SMITH@ATC has DBOPEN mode 5 access to the database. 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 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.
* The PASS= parameter of the UPDATE USER command is used to change
the password associated with the IMAGE/SQL user. The password
specified must exist in the TurboIMAGE/XL database schema.