You can execute the DROP USER statement to delete one or more users from ApsaraDB for OceanBase.
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.
DROP USER username [, username...] ;
The username. To delete multiple users at a time, separate the usernames with commas (,).
Run the following command to delete user sqluser02:
oceanBase(admin@TEST)>drop user sqluser02; Query OK, 0 rows affected (0.02 sec)