ContextQMD
Back to Materialize

DROP ROLE

doc/user/content/sql/drop-role.md

123879 B
Original Source

DROP ROLE removes a role from Materialize.

Syntax

mzsql
DROP ROLE [IF EXISTS] <role_name>;
Syntax elementDescription
IF EXISTSOptional. 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.

Details

You cannot drop the current role.

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/drop-role" %}}