DROP ROLE

Description

This statement is used to drop a role.

DROP ROLE role1;

Drop a role will not affect the grants of users who was previously of the role. It is only equivalent to decoupling the role from the user. The grants that the user has obtained from this role will not change. ​

Example

1. Drop a role

   DROP ROLE write_role;

Keywords

DROP, ROLE