|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
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. User sessions in which the role is already enabled are not affected. However, no new user session can enable the role after it is dropped.
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
dw_manager (created in "Creating a Role: Example"), issue the following statement: