Hive grant privileges on an object to a role

Question

Hi. How can I grant privileges on an object to a role in Hive? What is the command?

Answer 1

Use the GRANT <Privilege> statement to grant privileges on an object to a role. The statement uses the following syntax:

GRANT <privilege> [, <privilege> ] ON <object type> <object name> TO ROLE <role name> [,ROLE <role name>]