You can use the DROP USER syntax to delete the specified user of a Lindorm instance. You can use the SHOW USERS syntax to check all existing users of the current instance before you delete a user.
Applicable engines and versions
The DROP USER syntax is applicable to all versions of LindormTable and LindormTSDB.
Syntax
drop_user_statement ::= DROP USER [IF EXISTS] user_identifierParameters
User name (user_identifier)
The user_identifier parameter specifies the name of the user that you want to delete.
If the specified user name does not exist, and the IF EXISTS condition is not specified in the DROP USER statement, an error is returned to indicate that the user does not exist. If the IF EXISTS condition is specified in the DROP USER statement, the execution of the statement is terminated and no error is returned.
Examples
Delete a user named test_user.
DROP USER IF EXISTS test_user;