Versions Compared

Old Version 21

changes.mady.by.user Jason Dere

Saved on

compared with

New Version 22

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add version notes for ADMIN OPTION and GRANT OPTION (HIVE-6252 & HIVE-7404)

...

No Format
GRANT ROLE role_name [, role_name] ...
TO principal_specification [, principal_specification] ...
[WITH ADMIN OPTION]

REVOKE [ADMIN OPTION FOR] ROLE role_name [, role_name] ...
FROM principal_specification [, principal_specification] ...

principal_specification:
    USER user
  | GROUP group
  | ROLE role
Info
titleVersion

[WITH ADMIN OPTION] was added to GRANT ROLE in Hive 0.13.0.

[ADMIN OPTION FOR] will be added to REVOKE ROLE in Hive 0.14.0 (HIVE-).

 

Viewing Granted Roles

No Format
SHOW ROLE GRANT principal_specification
 
principal_specification:
    USER user
  | GROUP group
  | ROLE role

...