HP 3000 Manuals HP 3000 Manuals
Updating Information about IMAGE/SQL Users: Task 6
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 (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 SQL syntax User@Account is used to add an IMAGE/SQL 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 IMAGE/SQL user. The password
specified must exist in the TurboIMAGE/XL[REV BEG] database
schema.[REV END]