Skip to main content
VeloDB Cloud 26.x·Apache Doris 4.x (≤ 4.0 supported)·"Since X.Y" tags refer to Doris versionsversion mapping →

DROP USER

Description​

The DROP USER statement is used to delete a user.

Syntax​

  DROP USER <user_identity>

Required Parameters​

1. <user_identity>

The specified user identity.

Access Control Requirements​

The user executing this SQL command must have at least the following privileges:

PrivilegeObjectNotes
ADMIN_PRIVUSER or ROLEThis operation can only be performed by users or roles with ADMIN_PRIV permissions

Example​

  • Delete user jack@'192.%'
DROP USER 'jack'@'192.%'