HP 3000 Manuals HP 3000 Manuals
Deleting Turbo CONNECT Users: Task 7
This task describes how to delete Turbo CONNECT users.
Getting Ready
To perform this task, you must be both the TurboIMAGE/XL DBC and an
ALLBASE/SQL DBA.
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 5 CLERK 14 |
| |
| >> |
________________________________________________________________
Performing the Task
Use the DELETE USER command to delete a Turbo CONNECT user. For example:
_____________________________________
| |
| >> DELETE USER SMITH@ATC |
| >> |
_____________________________________
Here, SMITH@ATC is deleted as a Turbo CONNECT user and removed from the
corresponding authorization group.
The DISPLAY USER command now reflects the deletion.
________________________________________________________________
| |
| >>DISPLAY USER |
| |
| TurboIMAGE/XL DB : SALES.SERED.ATC |
| DBEnvironment : PARTSDBE.SERED.ATC |
| |
| USER LOGON DBOPEN MODE USER PASSWORD USER CLASS|
| ---------- ----------- ------------- ----------|
| |
| NANCY@ATC 5 ; 64 |
| |
| >> |
________________________________________________________________
Note that SMITH@ATC is still configured as an ALLBASE/SQL user, however,
because native ALLBASE/SQL tables and views may be owned by this
User@Logon.
Task Reference
* When the last ALLBASE/SQL user logon associated with a TurboIMAGE/XL
user class is deleted, the ALLBASE/SQL authorization group
(OwnerName_UserClass#) and views associated with this user class are
not dropped. Doing so would invalidate any views that may have been
created based on these Turbo CONNECT views.
* 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.