Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: remove stray sentence at beginning, edit its duplicate per Thejas email

If a user is granted a privilege WITH GRANT OPTION on a table or view, then the user can also grant other users the privileges it has on those tables. 


Table of Contents
maxLevel3

Status of Hive Authorization before Hive 0.13

...

If a user is granted a privilege WITH GRANT OPTION on a table or view, then the user can also grant that privilege to /revoke privileges of other users or roleson those objects. As of Hive 0.14.0, the grant option for a privilege can be removed while still keeping the privilege by using REVOKE GRANT OPTION FOR <privilege> (HIVE-7404).

Note that in case of the REVOKE statement, the DROP-BEHAVIOR option of CASCADE is not currently supported (which is in SQL standard). As a result, the revoke statement will not drop any dependent privileges. For details on CASCADE behavior, you can check the Postgres revoke documentation.

...