Thanks Robert & Larry. ...
Thanks Robert & Larry.
Hi - I have installed HDP in a 3 node cluster & configured hive with mysql.
Question is - Any O/S user is able to get into hive & create their own DB + they can drop or modify others as well.
Is there an config entry that can be controlled to avoid this - meaning, users should not have create database (in hive) privilege by default - but should be given on demand basis.
Also - how can we make sure user1 will not query or see user2 db - unless the privelge is given explictily (say, using a ROLE).
Thanks in advance,