Can we enable hive ACL'S without ranger ?

[#1]

I want want to restrict users on hive tables , Grant them with select permission only

[#2]

you have 2 ways of handling permissions here : storage-based (so user will have select permission only if he's only got read rights on HDFS files), or SQL-based : https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization

[#3]

What do i need to add user to admin role ?

[#4]

find your answer in @Benjamin Leonhardi comment below 🙂

[#5 · Accepted solution]

I wrote a little article on getting started with SQL STD Auth. I implemented it and did quite like it.

https://community.hortonworks.com/content/kbentry/597/getting-started-with-sqlstdauth.html