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, 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.

Task 6: Updating Information about IMAGE/SQL Users

Technical documentation

» Table of Contents

» Glossary

» Index