SQL - SQLCODE's - Códigos negativos -557


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 -557
   
 
  • Causa
    • INCONSISTENT GRANT/REVOKE KEYWORD keyword.
      PERMITTED KEYWORDS ARE keyword-list

      The GRANT or REVOKE statement contains a syntax or spelling error at or before the specified 'keyword'.
      As an aid to the programmer, 'keyword-list' provides a list of the keywords that would be permitted in this context.

      Alternatively:

      • The mixture of privileges specified on the GRANT or REVOKE statement is not permitted.
        The privileges must all be of one type, and consistent with the form of the GRANT or REVOKE statement.
      • REVOKE UPDATE (column-list) is not permitted; only REVOKE UPDATE is valid.
      • The keywords DELETE, INSERT, SELECT, TRIGGER, UPDATE, REFERENCES and ALTER cannot be specified for an auxiliary table.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the syntax of the GRANT or REVOKE statement.

      SQLSTATE: 42852

© Copyright IBM Corp.