602SQL Documentation Index  

DROP USER Statement

statement_DROP_USER ::= DROP [ IF EXISTS ] USER user_name


The DROP USER statement deletes a user with the specified name.

If the user of the specified name does not exist in the database, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

Users may be deleted by a security or configuration administrator.


Deletes the XUSER user and the XGROUP group.

DROP USER xuser;
DROP GROUP xgroup;