DROP USER

DROP USER removes a role from Materialize.

Syntax

Field	Use
IF EXISTS	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.

Details

DROP USER is an alias for DROP ROLE.

Privileges

The privileges required to execute this statement are:

• CREATEROLE privileges on the system.

Related pages

• ALTER ROLE
• CREATE ROLE
• DROP ROLE
• GRANT ROLE
• REVOKE ROLE
• GRANT PRIVILEGE
• REVOKE PRIVILEGE