|Oracle8i SQL Reference
Release 2 (8.1.6)
SQL Statements (continued), 17 of 30
To remove a role from the database. When you drop a role, Oracle revokes it from all users and roles to whom it has been granted and removes it from the database.
You must have been granted the role with the
OPTION or you must have the
ROLE system privilege.
is the role to be dropped.
To drop the role
FLORIST, issue the following statement: