SQL Guide : Using SQL for database administration : Managing user privileges and roles : Deleting roles
  
Deleting roles
DROP ROLE role_name;
The following example deletes the user role named GUEST_USERS.
DROP ROLE GUEST_USERS;
See also
Managing user privileges and roles