You can switch to the database and grant privileges on the table.   USE jranalyst; GRANT SELECT ON TABLE a TO ROLE c;   Hive currently doesnt support fully qualified table names (db1.tb1) in grant/revoke sql, and that is the reason you will need to switch to the database first to be able to grant privileges on a table.   ... View more