DROP ROLE

Description

Removes the specified role from the system.

Syntax

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

Examples

  1. > drop role if exists rolex;
  2. 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.