Authorization
The privileges held by the authorization ID of the statement must include
at least one of the following:
- If the procedure is an SQL procedure:
- The EXECUTE privilege on the procedure, and
- The system authority *EXECUTE on the library containing the SQL procedure
- If the procedure is a Java(TM) external procedure:
- Read authority (*R) to the integrated file system file that contains the Java class.
- Read and execute authority (*RX) to all directories that must be accessed
in order to find the integrated file system file.
- If the procedure is a REXX external procedure:
- The system authorities *OBJOPR, *READ, and *EXECUTE on the source file
associated with the procedure,
- The system authority *EXECUTE on the library containing the source file,
and
- The system authority *USE to the CL command,
- If the procedure is an external procedure, but not a REXX or Java external
procedure:
- The system authority *EXECUTE on the program or service program associated
with the procedure, and
- The system authority *EXECUTE on the library containing the program or
service program associated with the procedure
- Administrative authority
For information on the system authorities corresponding to SQL privileges,
see Corresponding System Authorities When Checking Privileges to a Function or Procedure.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.