HP 3000 Manuals HP 3000 Manuals
DELETE USER
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
* 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 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 |
| >> |
_____________________________________