Example

Example 1: Revoke the EXECUTE privilege on package PKGA from PUBLIC.

   REVOKE EXECUTE
     ON PACKAGE PKGA
     FROM PUBLIC

Example 2: Revoke the EXECUTE privilege on package RRSP_PKG from user FRANK and PUBLIC.

   REVOKE EXECUTE
     ON PACKAGE RRSP_PKG
     FROM FRANK, PUBLIC