Authorization
For any form of a query, the privileges held by the authorization ID of the statement must include at least one of the following:
- For each table or view identified in the statement,
- The SELECT privilege on the table or view, and
- The system authority *EXECUTE on the library containing the table or view
- Administrative authority
If a query includes a user-defined function,
the privileges held by the authorization ID of the statement must include
at least one of the following:
- For each user-defined function identified in the statement:
- The EXECUTE privilege on the function
- Administrative authority
For information about the system authorities corresponding to SQL privileges, see Corresponding System Authorities When Checking Privileges to a Table or View or Corresponding System Authorities When Checking Privileges to a Function or Procedure.