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, user class, 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 or CLASS 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= 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.