+4726 THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE EXECUTED BECAUSE authorization-id DOES NOT HAVE privilege-name PRIVILEGE ON OBJECT object-name BUT HAS EXPLAIN PRIVILEGE

Explanation

During prepare, the authorization ID does not have the indicated privilege for an object but has EXPLAIN privilege.

authorization-id
The authorization ID of the process.
object-name
The name of the object that the privilege applies to.
privilege-name
The name of the privilege required to prepare the statement.

The statement that was prepared by using the EXPLAIN privilege cannot be executed, and a cursor cannot be opened for the statement. Only the SQL descriptor information can be obtained from the prepared statement.

The following authorities have implicit EXPLAIN privilege:
  • SQLADM
  • System DBADM
  • SYSADM

System action

The prepared statement was not executed. No cursor was opened for the statement.

Programmer response

Ensure that no OPEN or EXECUTE statements refer to the prepared statement.

SQLSTATE

0168Z