Who Can Drop a Package Body
The DROP PACKAGE BODY
statement can be executed by:
-
The owner of the package
-
Users with the
ALTER ANY PACKAGE
privilege
The DROP PACKAGE BODY
statement can be executed by:
The owner of the package
Users with the ALTER ANY PACKAGE
privilege
DROP PACKAGE BODY
DROP PACKAGE BODY APP_VAR;