Skip to main content

DROP USER

Use the DROP USER command to remove a user from RisingWave.

Syntax

DROP USER [ IF EXISTS ] user_name [ , ... ];

Parameters

ParameterDescription
IF EXISTSDo not return an error if the specified user does not exist.
user_nameThe user you want to drop.
- You cannot drop the current user;
- To drop a superuser (user with the SUPERUSER privilege), you must be a superuser yourself;
- To drop a non-superuser, you must have the CREATEUSER privilege.

Examples

The following statement removes the user with the name "user1".

DROP USER user1;

Help us make this doc better!