Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: expanding priv_type in grant/revoke syntax

...

Code Block
languagetext
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).

...