SQLTeam.com | Weblogs | Forums

Hive grant database scope permission

Is it feasible to offer access to all tables in the hive database? HBase supports granting permission at the global, namespace, and column qualifier levels.
In the hive, I've set up SQL standard-based authorization. Is it feasible to provide permission to a database directly rather than a specific table or view.

grant select on database database_name to user user_name

Is it possible to accomplish the same operation using hive native SQL standard-based authorization?
Thank you in advance.

USE YourDBNameHere
GO
ALTER ROLE db_datareader ADD MEMBER UsernameHere
GO