This task describes how to delete IMAGE/SQL users.
Getting Ready
To perform this task, you must be both the TurboIMAGE/XL DBC and an SQL DBA.
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 5 CLERK 14
>>
|
Performing the Task
Use the DELETE USER command to delete an IMAGE/SQL user.
For example:
>>DELETE USER SMITH.ATC
>>
|
Here, SMITH.ATC is deleted as an IMAGE/SQL 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 SQL user because
ALLBASE/SQL tables and views may be owned by this User.Logon.
Task Reference
When the last SQL user logon associated with a TurboIMAGE/XL user class is deleted,
the 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 IMAGE/SQL views.
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.