Skip to main content
Version: 2.5

DROP ROLE

Description

This statement allows users to delete a role.

Syntax

DROP ROLE <role_name>

Deleting 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;