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;