Synopsis
DROP ROLE role_name
Removes a role (role_name) from the database.
Note
You must have been granted the role via the WITH ADMIN OPTION, or you
must have the DROP ANY ROLE privilege to remove a role.
Example
The following example removes the operator role from the database:
DROP ROLE operator