# DROP USER

The `DROP USER` statement removes one or more SQL users.

Note:

New in v20.1: 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`.

## Required privileges

New in v20.1: To drop other non-admin users, the user must have the `CREATEROLE` parameter set.

## Synopsis

## 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` 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.

    > SHOW GRANTS ON test.customers FOR mroach;

    +-----------+--------+------------+
    |   Table   |  User  | Privileges |
    +-----------+--------+------------+
    | customers | mroach | CREATE     |
    | customers | mroach | INSERT     |
    | customers | mroach | UPDATE     |
    +-----------+--------+------------+
    (3 rows)

    > REVOKE CREATE,INSERT,UPDATE ON test.customers FROM mroach;

    > DROP USER mroach;

## See also

- `CREATE USER`
- `ALTER USER`
- `SHOW USERS`
- `GRANT`
- `SHOW GRANTS`
- Create Security Certificates
- Other SQL Statements