Description
This statement deletes an ApsaraDB for OceanBase user. Note
To run the DROP USER command, you must have the CREATE USER system permission.
CASCADE specifies that before a user is deleted, all the objects for the user, such as permissions, databases, and tables, are deleted.
Syntax
DROP USER username CASCADE;
Parameter description
| Parameter | Description |
|---|---|
| username | The username. Only a single user can be deleted. |
Examples
- Run the following command to delete the user that is named sqluser.
oceanBase(admin@TEST)>DROP USER sqluser CASCADE;
Query OK, 0 rows affected (0.06 sec)