Description

ALL or ALL PRIVILEGES
Revokes one or more package privileges from each authorization-name. The privileges revoked are those privileges on the identified packages that were granted to the authorization-names. Note that revoking ALL PRIVILEGES on a package is not the same as revoking the system authority of *ALL.

If you do not use ALL, you must use one or more of the keywords listed below. Each keyword revokes the privilege described.

ALTER
Revokes the privilege to use the COMMENT and LABEL statements.
EXECUTE
Revokes the privilege to execute statements in a package.
ON PACKAGE package-name
Identifies the packages from which you are revoking privileges. The package-name must identify a package that exists at the current server.
FROM
Identifies from whom the privileges are revoked.
authorization-name,...
Lists one or more authorization IDs. Do not specify the same authorization-name more than once.
PUBLIC
Revokes the specified privileges from PUBLIC.