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 | ||
---|---|---|
|
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.
...