...
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 | ||
---|---|---|
| ||
GRANT ROLE added the optional WITH ADMIN OPTION clause in Hive 0.13.0 (HIVE-5923). REVOKE ROLE will add the optional ADMIN OPTION FOR clause in Hive 0.14.0 (HIVE-6252). |
Viewing Granted Roles
No Format |
---|
SHOW ROLE GRANT principal_specification principal_specification: USER user | GROUP group | ROLE role |
...
No Format |
---|
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... [ON object_type] TO principal_specification [, principal_specification] ... [WITH GRANT OPTION] REVOKE [GRANT OPTION FOR] priv_type [(column_list)] [, priv_type [(column_list)]] ... [ON object_type priv_level] FROM principal_specification [, principal_specification] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... priv_type: ALL | ALTER | UPDATE | CREATE | DROP | INDEX | LOCK | SELECT | SHOW_DATABASE object_type: TABLE | DATABASE priv_level: db_name | tbl_name principal_specification: USER user | GROUP group | ROLE role |
Info | ||
---|---|---|
| ||
REVOKE priv_type will add the optional GRANT OPTION FOR clause in Hive 0.14.0 (HIVE-7404). |
Viewing Granted Privileges
...