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)
