v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support Unsupported versions

DROP USER

Synopsis

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

Syntax

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

drop_user

DROPUSERIFEXISTS,role_name

Semantics

See DROP ROLE for more details.

Example

  • Drop a user.

    yugabyte=# DROP USER John;

See also