Hive Revoke SELECT privilege from a Role

Question

Hi. I had created a hive table and had granted SELECT privilege on a column to a role. Now I want to revoke this privilege. How can I do this?

Answer 1

The following command can be used to revoke the SELECT privilege on a column:

REVOKE SELECT <column name> ON TABLE <table name> FROM ROLE <role name>;