Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

hue beexwax privilege(hive security)

avatar
Contributor

Is there a way to forbidden the user drop hive table,

If do not want the user have DDL privilege ,how to do that?

1 ACCEPTED SOLUTION

avatar
Super Guru
4 REPLIES 4

avatar
Super Guru

avatar
Contributor

avatar
Super Guru
The correct (but more complicated way) would be to use Sentry:
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.5.0/CDH4-Security-Guide/cdh4sg...

The other alternative is to remove the metastore DDL permissions in the
groups of your users: https://www.dropbox.com/s/nbv0wwpybwlsm67/hue-ddl.png,
but this will not secure the SQL like DROP table

Romain

avatar
Contributor

Thank you very much.

It works with sentry.