---
title: "DROP USER"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/dcl_drop_user/"
---

# DROP USER

Use the DROP USER statement to drop a user or role. DROP USER is an alias for DROP ROLE.

## Synopsis

Use the DROP USER statement to drop a user or role. DROP USER is an alias for [DROP ROLE](/stable/api/ysql/the-sql-language/statements/dcl_drop_role "DROP ROLE") and is used to drop a role.

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
drop_user ::= DROP USER [ IF EXISTS ] role_name [ , ... ]
```

#### drop\_user

DROPUSERIFEXISTS,[role\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#role-name)

## Semantics

See [DROP ROLE](/stable/api/ysql/the-sql-language/statements/dcl_drop_role "DROP ROLE") for more details.

## Example

- Drop a user.
  
  ```plpgsql
  yugabyte=# DROP USER John;
  ```

## See also

- [CREATE ROLE](/stable/api/ysql/the-sql-language/statements/dcl_create_role "CREATE ROLE")
- [ALTER ROLE](/stable/api/ysql/the-sql-language/statements/dcl_alter_role "ALTER ROLE")
- [GRANT](/stable/api/ysql/the-sql-language/statements/dcl_grant "GRANT")
- [REVOKE](/stable/api/ysql/the-sql-language/statements/dcl_revoke "REVOKE")