Authorization
The privileges held by the authorization id of the statement must include
at least one of the following:
- For the SYSFUNCS 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 object to contain the information
necessary to save/restore the function to another system. If user does not
have this authority, the function is still created, but the program object
is not updated.
- Administrative Authority
If SQL names are specified and a user profile exists that has the same
name as the library into which the function is created, and that name is different
from the authorization ID of the statement, then the privileges held by the
authorization ID of the statement must include at least one of the following:
- The system authority *ADD to the user profile with that name
- 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 Table or View and Corresponding System Authorities When Checking Privileges to a Distinct Type.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.