HP 3000 Manuals HP 3000 Manuals
DELETE USER
Deletes an IMAGE/SQL user.
Syntax
DEL[ETE] USER 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 XL user and account name, connected with the @ symbol.
This user and account must be a valid existing logon.
Prerequisites
* SET SQLDBE issued.
* SET TURBODB issued.
* DBC status.
* DBA authority.
* Database attached.
Description
Use the DELETE USER command to delete an IMAGE/SQL user from a
DBEnvironment. When a user is deleted, the DBEUserID (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 |
| >> |
_____________________________________