SQL - SQLCODE's - Códigos positivos - +4726


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode +4726
   
 
  • Causa
    • 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

      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
  • Ação do sistema
    • The prepared statement was not executed. No cursor was opened for the statement.
  • Resposta ao Desenvolvedor
    • Ensure that no OPEN or EXECUTE statements refer to the prepared statement.

      SQLSTATE: 0168Z