Role assignment in Hive

0 投票
最新提问 用户: (140 分)

I created a role(granted select access to Database) in Hive and applied to my user. Role has only select access to particular database but my user is able to access all other databases too.

Can someone please advise ? what I'm I missing here

发表于 用户: (220 分)
do you have Ranger/Sentry for permission control?
发表于 用户: (140 分)
yes I do @shashi
发表于 用户: (220 分)
Did you try creating permission from Ranger ?


0 投票
最新回答 用户: (140 分)

Hive does not support privileges on databases (it may depend to version), see doc :

The privileges apply to table and views. The above privileges are not supported on databases

And you may miss some configuration, see here.

Dont forget that Hive is not good enough to manage permissions, so I highly recommand to set up permissions in the hdfs layer not in Hive layer.

欢迎来到 Security Q&A ,有什么不懂的可以尽管在这里提问,你将会收到社区其他成员的回答。