Deletes an IMAGE/SQL user.
Syntax |
 |
DEL[ETE] USER { User@Account User.Account }
Parameters |
 |
- User@Account
is the name used to identify the IMAGE/SQL
user to SQL. This name, referred to as the
DBEUserID, is made up of an MPE/iX user and account name, connected
with the period or @ symbol.
This user and account must be a valid existing logon.
Prerequisites |
 |
Description |
 |
Use the DELETE USER command to delete an IMAGE/SQL user from a DBEnvironment.
When a user is deleted, the DBEUserID (User@Account or User.Account)
is removed from the SQL group associated with the TurboIMAGE/XL user class.
Note that the group itself and
the corresponding view(s) remain in the DBEnvironment
because other user-created views
may be based on views created by IMAGE/SQL.
Example |
 |
In the example below, once the DELETE USER command is issued, user RYAN.ATC can no longer
access the SALES database with IMAGE/SQL.
>>DELETE USER RYAN.ATC
>>
|