Support Questions

Find answers, ask questions, and share your expertise

Can we enable hive ACL'S without ranger ?

avatar
Super Collaborator

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

1 ACCEPTED SOLUTION

avatar
Master Guru

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

View solution in original post

4 REPLIES 4

avatar
Guru

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

avatar
Super Collaborator

What do i need to add user to admin role ?

2688-hive-sql.png

avatar
Guru

find your answer in @Benjamin Leonhardi comment below 🙂

avatar
Master Guru

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