Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : DROP USER
 
DROP USER
The DROP USER statement removes user accounts from a database.
Syntax
DROP USER [ IF EXISTS ] user-name [ , user-name ]...
Remarks
Only the Master user can execute this statement.
Security must be turned on to perform this statement.
Separate multiple user names with a comma.
If the user name contains spaces or other nonalphanumeric characters, it must be enclosed in double quotation marks.
Dropping a user account does not delete the tables, views, or other database objects created by the user.
The expression IF EXISTS causes the statement to return success instead of an error if a user does not exist. IF EXISTS does not suppress other errors.
For further general information about users and groups, see Master User and Users and Groups in Advanced Operations Guide, and Assigning Permissions Tasks in Zen User’s Guide.
Examples
The following example removes the user account pgranger.
DROP USER pgranger
============ 
The following example removes multiple user accounts.
DROP USER pgranger, "lester pelling"
See Also
ALTER USER
CREATE USER