# DROP USER

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

Tip:
You can also use the `cockroach user rm` command to remove users.

## Required privileges

The user must have the `DELETE` privilege on the `system.users` table.

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

- `cockroach user` command
- `CREATE USER`
- `SHOW USERS`
- `GRANT`
- `SHOW GRANTS`
- Create Security Certificates
- Other SQL Statements