Outdated Version

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

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