|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 30 of 31
ROLE statement 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.
Specify the name of the role to be dropped.
To drop the role
florist, issue the following statement: