Authorization
The privileges held by the authorization ID of the statement must include
at least one of the following:
- For the SYSPROCS catalog view and SYSPARMS catalog table:
- The INSERT privilege on the table, and
- The system authority *EXECUTE on library QSYS2
- Administrative authority
If the external program or service program exists, the privileges held
by the authorization ID of the statement must include at least one of the
following:
- For the external program or service program that is referenced in the
SQL statement:
- The system authority *EXECUTE on the library that contains the external
program or service program.
- The system authority *EXECUTE on the external program or service program,
and
- The system authority *CHANGE on the program or service program. The system
needs this authority to update the program or service program object to contain
the information necessary to save/restore the procedure to another system.
If user does not have this authority, the procedure is still created, but
the program or service program object is not updated.
- Administrative Authority
If a distinct type is referenced, the privileges held by the authorization ID of
the statement must include at least one of the following:
- For each distinct type identified in the statement:
- The USAGE privilege on the distinct type, and
- The system authority *EXECUTE on the library containing the distinct type
- Administrative authority
For information on the system authorities corresponding to SQL privileges,
see Corresponding System Authorities When Checking Privileges to a Function or Procedure and Corresponding System Authorities When Checking Privileges to a Distinct Type.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.