In this post, you’ll learn about the error message -557 inconsistent grant/revoke keyword keyword.� permitted keywords are keyword list in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-557 inconsistent grant/revoke keyword keyword.� permitted keywords are keyword list
Reason for the Error
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.
Solution
Correct the syntax of the GRANT or REVOKE statement.
