All Products
Search
Document Center

DROP USER

Last Updated: Jun 18, 2021

Description

You can execute the DROP USER statement to delete one or more users from ApsaraDB for OceanBase.

Note

  • To execute the DROP USER statement, ensure that you have the global permission to execute the CREATE USER statement.

  • You cannot execute a DELETE statement to manage permissions on the mysql.user table.

  • After a user is deleted, all permissions of the user are removed.

Syntax

DROP USER username [, username...] ;

Parameters

Parameter

Description

username

The username. To delete multiple users at a time, separate the usernames with commas (,).

Examples

Run the following command to delete user sqluser02:

oceanBase(admin@TEST)>drop user sqluser02;
Query OK, 0 rows affected (0.02 sec)