In this blog post, let’s learn about the error message “279 Cannot grant or revoke database privileges for table or view.” in Hydra and the description of the error.
Error Message
279 Cannot grant or revoke database privileges for table or view.
Error Details
This UPDATE WHERE CURRENT OF cursor statement refers to a different table than the table referenced by the SELECT statement that was declared with the cursor. Review the program logic to make sure that an update through a cursor updates only the table that the cursor is reading. This message also applies to cursor statements that use DELETE WHERE CURRENT OF.