DROP USER
Use the DROP USER
command to remove a user from RisingWave.
Syntax
DROP USER [ IF EXISTS ] user_name [ , ... ];
Parameters
Parameter | Description |
---|---|
IF EXISTS | Do not return an error if the specified user does not exist. |
user_name | The 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;