DROP USER

Removes the specified user from the system.

Description

Removes the specified user from the system.

Syntax

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

User names are case-sensitive within the current account. Mixed-case names and Unicode/CJK characters are preserved when MatrixOne resolves users to drop. DROP USER IF EXISTS only suppresses the missing-user error for names that do not match an existing user exactly.

Examples

> drop user if exists userx;
Query OK, 0 rows affected (0.02 sec)

Note

If the user is in a session, when the user is removed, the session is disconnected and MatrixOne can no longer be connected.