-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