Hydra Error 379 Cannot revoke privilege on columns.

Posted by AbundantCode

In this blog post, let’s learn about the error message “379 Cannot revoke privilege on columns.” in Hydra and the description of the error.

Error Message

379 Cannot revoke privilege on columns.

Error Details

In the GRANT statement, you can grant UPDATE or SELECT privilege on specific columns. However, the REVOKE statement accepts only the keywords for the type of privilege; you cannot revoke access to specific columns. If you want to change the columns allowed to a certain user, you must first REVOKE the privilege in full, then GRANT it on the new list of columns.