DROP USER

Warning:
Cockroach Labs will stop providing Assistance Support for this version on May 10, 2022. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see the Release Support Policy.

The DROP USER statement removes one or more SQL users.

Note:

Since the keywords ROLE and USER can now be used interchangeably in SQL statements for enhanced Postgres compatibility, DROP USER is now an alias for DROP ROLE.

Consideration

Users that own objects (such as databases, tables, schemas, and types) cannot be dropped until the ownership is transferred to another user.

Required privileges

Non-admin users cannot drop admin users. To drop non-admin users, the user must be a member of the admin role or have the CREATEROLE parameter set.

Synopsis

DROP USER IF EXISTS user_name ,
## Parameters Parameter | Description -----------|------------- `user_name` | The username of the user to remove. To remove multiple users, use a comma-separate list of usernames.

You can use [`SHOW USERS`](show-users.html) to find usernames. ## Example All of a user's privileges must be revoked before the user can be dropped. In this example, first check a user's privileges. Then, revoke the user's privileges before removing the user.
icon/buttons/copy
> SHOW GRANTS ON test.customers FOR mroach;
+-----------+--------+------------+
|   Table   |  User  | Privileges |
+-----------+--------+------------+
| customers | mroach | CREATE     |
| customers | mroach | INSERT     |
| customers | mroach | UPDATE     |
+-----------+--------+------------+
(3 rows)
icon/buttons/copy
> REVOKE CREATE,INSERT,UPDATE ON test.customers FROM mroach;
icon/buttons/copy
> DROP USER mroach;

See also

YesYes NoNo