DROP ROLE

Description

This statement allows users to drop a role.

NOTE

System built-in roles account_admin and org_admin cannot be dropped.

Syntax

DROP ROLE <role_name>

Dropping a role does not affect permissions of users who previously belonged to this role. It only decouples the role from the user without changing permissions that user has already obtained from the role.

Examples

Drop a role.

  DROP ROLE role1;