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