DROP ROLE

Removes the specified role from the system.

Description

Removes the specified role from the system.

Syntax

> DROP ROLE [IF EXISTS] role [, role ] ...

Role names are case-sensitive within the current account. Mixed-case names and Unicode/CJK characters are preserved when MatrixOne resolves roles to drop. DROP ROLE IF EXISTS only suppresses the missing-role error for names that do not match an existing role exactly.

Examples

> drop role if exists rolex;
Query OK, 0 rows affected (0.02 sec)

Note

If the user using this role is in a session, when the role is removed, the session will be disconnected immediately, and this role can no longer be used for operations.