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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.