You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.


Removes one or more user accounts.


DROP USER [IF EXISTS] user [, user] ...


  • user - valid user account
  • Use GRANT to create a user account and assign privileges.
  • This command can be run on any MemSQL node (see Node Requirements for MemSQL 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.


memsql> DROP USER myAdmin;