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:

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.