...
Code Block | ||
---|---|---|
| ||
REVOKE [GRANT OPTION FOR]
priv_type [, priv_type ] ...
ON table_or_view_name
FROM principal_specification [, principal_specification] ... ;
principal_specification
: USER user
| ROLE role
priv_type
: INSERT | SELECT | UPDATE | DELETE | ALL |
If a user is granted a privilege WITH GRANT OPTION on a user or a role, then the user can also grant other users the privileges it has on those tables. As of Hive 0.14.0, the grant option for a privilege can be removed while still keeping the privilege using REVOKE GRANT OPTION FOR <privilege> (HIVE-7404).
...