> ## Documentation Index
> Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP USER

Remove an existing user.

## Synopsis

```
DROP USER user_name
```

## Description

The `DROP USER` command removes an existing user from the database.

If there is currently a connection to the database by the given user it will be terminated and all running transactions on that connection will be aborted.

Notes:

* A user can remove itself.
* If there is only one user, it cannot be removed.

## Parameters

**`user_name`**

The name of the user to remove.

## Examples

Remove a user:

```sql theme={null}
DROP USER user1;
```

## Compatibility

The `DROP USER` statement is a Regatta extension as there is no SQL standard for managing users.