I have created a fresh cluster , Hive is not allowing me to enter using the root user( Linux ) and even tried with HDFS user . However I'm able to login as user hive and able to run queries. How can I provide access to any user in Hive.For example,I have a local linux users
1. How can I grant permissions to use hive from their login . They are Ldap users by default.
2.How can I grant permissions to specific databases and restrict them with ( create /delete/update).
I'm sure this is very basic question . I haven't find any good document in Internet . Could anyone here please describe for everyone in the forum . I can understand this can be managed by Ranger . However we do not want Ranger in our system now . Please assist me
Yes if it's an HDP cluster Ranger is the only tool to make your administration for Authorization easy else it_dev,it_admin users can individually create their databases which won't be shareable. Unfortunately, even on CDH you have sentry which remind me of Oracle Admin where the permission/authorization is a 3 step and CLI based.
Advantage of Ranger
So your only option is to have each user create own database and tables , there is no concept of grant user X select, create etc in hive.
Hope that helps