SingleStore Managed Service

DROP USER

Removes one or more user accounts.

Syntax
DROP USER [IF EXISTS] user [, user] ...
Remarks
  • user - valid user account

  • Use GRANT to create a user account and assign privileges.

  • This command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands).

  • If If EXISTS is not specified, the command will fail if any user listed does not exist.

  • If IF EXISTS is specified, the command will still attempt to drop every user listed, even if some of the users listed do not exist.

Example
DROP USER myAdmin;