Purpose
You can use this statement to drop an OceanBase Database user.
Note
- You must have the
CREATE USERsystem privilege to use theDROP USERstatement. CASCADEindicates dropping all objects such as privileges, databases, and tables owned by the user before dropping the user.
Syntax
DROP USER user_name CASCADE;
Parameters
| Parameter | Description |
|---|---|
| user_name | The username. You can drop a single user at a time. |
Examples
Drop the user named user1.
obclient> DROP USER user1 CASCADE;
Query OK, 0 rows affected