Take a look at this, https://cwiki.apache.org/Hive/languagemanual-auth.html. This may be what you are looking for .
From: shashwat shriparv [mailto:[email protected]] Sent: Friday, May 18, 2012 3:08 PM To: [email protected] Subject: Re: Is there a way to create user account and grant read only permissions? Check out this https://ccp.cloudera.com/display/CDHDOC/Hive+Security+Configuration On Sat, May 19, 2012 at 12:17 AM, Patrick Luo <[email protected]<mailto:[email protected]>> wrote: My use case requires individual accounts for business users groups. Is there a way to mimic MySQL (or other database) to create users with read-only permissions? This avoid business user accidental table drop. Metastore has table ROLES but don’t see documentation on that. Much appreciated if anyone can point to the documentation or share your thoughts on this? - Patrick -- ∞ Shashwat Shriparv
