DROP ROLE statement allows you to drop a role from your database.
DROP ROLE roleName
The name of the role that you want to drop from your database.
Dropping a role has the effect of removing the role from the database
dictionary. This means that no session user can henceforth set that role
will now have a
Dropping a role also has the effect of revoking that role from any user
and role it has been granted to. See the
statement for information on how
revoking a role may impact any dependent objects.
splice> DROP ROLE statsEditor_role; 0 rows inserted/updated/deleted