DROP ROLE

Description

The statement user deletes a role

Grammar: DROP ROLE role1;

Deleting a role does not affect the permissions of users who previously belonged to that role. It is only equivalent to decoupling the role from the user. The permissions that the user has obtained from the role will not change.

example

1. Delete a role

DROP ROLE role1;

keyword

DROP, ROLE