CREATE USER Statement

SQL Statements

CREATE GROUP Statement

DROP USER Statement

statement_DROP_USER ::= DROP [ IF EXISTS ] USER user_name

Description

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.

Example:

Deletes the XUSER user and the XGROUP group.

DROP USER xuser;
DROP GROUP xgroup;

See

• CREATE USER
• DROP GROUP
• CREATE GROUP
• Privileges and privilege subjects in SQL

CREATE USER Statement

SQL Statements

CREATE GROUP Statement