DROP USER

Syntax

DROP USER 'email_address';

Description

Drops a user from the organization.

Only a role with the MANAGE_MEMBERS privilege can drop a user.

Arguments

email_address

The email address of the user to drop from the current organization.

Examples

Drop a User

The following drops the user with email [email protected]:

demodb.public/demostore# SHOW USERS;
+-------------+--------------+-------------+----------------------+------------+
|  Given Name |  Family Name |  Is Current |  Email               |  Locale    |
+=============+==============+=============+======================+============+
| Delta       | Stream       | false       | [email protected] | en         |
+-------------+--------------+-------------+----------------------+------------+
| Admin       | Stream       | true        | [email protected] | en         |
+-------------+--------------+-------------+----------------------+------------+
demodb.public/demostore# DROP USER '[email protected]';
+------------+----------------------+------------+------------------------------------------+
|  Type      |  Name                |  Command   |  Summary                                 |
+============+======================+============+==========================================+
| user       | [email protected] | DROP       | user [email protected] was dropped    |
|            |                      |            | from the organization                    |
+------------+----------------------+------------+------------------------------------------+