All Products
Search
Document Center

DROP USER

Last Updated: Jun 18, 2021

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)