It is all documented here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Authorization
Disclaimer Hive authorization is not completely secure. In its current form, the authorization scheme is intended primarily to prevent good users from accidentally doing bad things, but makes no promises about preventing malicious users from doing malicious things. Thanks, Vinod http://blog.vinodsingh.com/ On Mon, May 14, 2012 at 6:27 AM, Ranjith <ranjith.raghuna...@gmail.com>wrote: > With 0.7.1 hive allows for grants on tables and some ability to restrict > table alterations. What shortcomings are compensated for with multiple > instances versus those? > > Thanks, > Ranjith > > On May 13, 2012, at 3:32 PM, Vinod Singh <vi...@vinodsingh.com> wrote: > > Yes, security is one of the motivation. As hive is weak on security, > keeping separate warehouses makes the data secure. > > Thanks, > Vinod > > http://blog.vinodsingh.com/ > > On Sun, May 13, 2012 at 10:44 PM, Ranjith <ranjith.raghuna...@gmail.com>wrote: > >> Given that hive has the concept of multiple databases to categorize >> objects. What is the motivation behind having multiple hive instances? I am >> curious here.......is it for security? >> >> Thanks, >> Ranjith >> >> On May 13, 2012, at 9:53 AM, Vinod Singh <vi...@vinodsingh.com> wrote: >> >> >> That if perfectly fine. Even each user can have their own warehouse >> directory. >> >> Thanks, >> Vinod >> >> On Sun, May 13, 2012 at 5:37 PM, Xiaobo Gu <guxiaobo1...@gmail.com>wrote: >> >>> Hi, >>> >>> If we set different hive.metastore.warehouse.dir for the different >>> Hive instances, it this ok, does them conflict with other resouces, >>> such as directory paths under /tmp? >>> >>> Regards, >>> >>> Xiaobo Gu >>> >> >> >