Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DROP USER

Info

SingleStore Managed Service does not support this command.

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 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;