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;