Outdated Version

You are viewing an older version of this section. View current production version.

DROP USER

Info

MemSQL Helios 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 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.

Example

memsql> DROP USER myAdmin;