drop-user.md 922 B


title: "DROP USER" description: "DROP USER removes a role from Materialize." menu: main:

parent: commands

DROP USER removes a role from Materialize.

Syntax

{{< diagram "drop-user.svg" >}}

Field Use
IF EXISTS Do not return an error if the specified role does not exist.
_rolename The role you want to drop. For available roles, see mz_roles.

Details

DROP USER is an alias for DROP ROLE.

Privileges

The privileges required to execute this statement are:

{{< include-md file="shared-content/sql-command-privileges/drop-user.md" >}}

Related pages