DROP ROLE

DROP ROLE 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

You cannot drop the current role.

Privileges

The privileges required to execute this statement are:

• CREATEROLE privileges on the system.

Related pages

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