DROP USER

Deletes a user. For more information, see Managing users.

A user cannot be dropped if it owns objects. In this case, an error message will be displayed, and you need to manually drop the objects, or transfer ownership.

for more information, see Ownership.

Syntax

DROP USER [ IF EXISTS ] <user_name> ;

Parameters

Parameter	Description
`<user_name>`	The name of the user to delete. If the user name contains spaces or non-alphanumeric characters, it must be enclosed in single or double quotes.

Example

The following command will delete the “alex” user.

DROP USER alex;

DROP ROLE

GRANT

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Example

​Syntax

​Parameters

​Example

Syntax

Parameters

Example