DROP USER
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP USER statement deletes an existing user. For details about users, see the Security Guide.
Users that own databases cannot be dropped. If a user that owns database objects is dropped, the objects are not dropped.
The DROP USER statement has the following format:
[EXEC SQL] DROP USER user_name;
Embedded Usage
You cannot use host language variables in an embedded DROP USER statement.
You must have MAINTAIN_USERS privilege and be connected to the iidbdb database.
Locking
The DROP USER statement locks pages in the iiuser system catalog in the iidbdb.
Related Statements
ALTER USER
CREATE USER
GRANT (privilege)
Last modified date: 01/30/2023