drop-role.md 933 B


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

parent: commands

DROP ROLE removes a role from Materialize.

Syntax

{{< diagram "drop-role.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

You cannot drop the current role.

Privileges

The privileges required to execute this statement are:

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

Related pages