DROP ROLE

Purpose

Use the DROPROLE statement to remove a role from the database. When you drop a role, Oracle Database 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.

See Also:

CREATE ROLE and ALTER ROLE for information on creating roles and changing the authorization needed to enable a role