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