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;

Was this Article Helpful?

Thanks For Your Feedback!