DROP USER

DROP USER removes a role from Materialize. DROP USER is an alias for DROP ROLE.

Syntax

DROP USER [IF EXISTS] <role_name>;
Syntax element Description
IF EXISTS Optional. If specified, do not return an error if the specified role does not exist.
<role_name> The role you want to drop. For available roles, see mz_roles.

Privileges

The privileges required to execute this statement are:

  • CREATEROLE privileges on the system.
Back to top ↑