-557 INCONSISTENT GRANT/REVOKE KEYWORD keyword. PERMITTED KEYWORDS ARE keyword-list

Explanation

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.

System action

The statement cannot be processed.

Programmer response

Correct the syntax of the GRANT or REVOKE statement.

SQLSTATE

42852