DROP ROLE
Use the DROP ROLE
command to drop an existing
role.
Syntax
DROP ROLE 'role_name';
The role_name is a text string containing the unique name of the role being dropped. When you drop a role, all of the related role permissions are dropped.
Example
drop role 'AutoAdmin';