logo  
Google
 

DB2 SQL-Error: -557

SQLState: 42852

Short Description: INCONSISTENT GRANTREVOKE KEYWORD PERMITTED KEYWORDS ARE

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: v 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. v REVOKE UPDATE (column-list) is not permitted; only REVOKE UPDATE is valid. v The keywords DELETE, INSERT, SELECT, TRIGGER, UPDATE, REFERENCES and ALTER cannot be specified for an auxiliary table.System action: The statement cannot be executed. Programmer response: Correct the syntax of the GRANT or REVOKE statement.

 <-  BACK TO INDEX