Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Is there a way to create user account and grant read only permissions?


Copy link to this message
-
Re: Is there a way to create user account and grant read only permissions?
Hi patrick
      The Authorization mechanisms in hive are not as solid as other RDBMS. A user can grant himself rights and can then drop a table or do whatever operations he likes to do. There is no super user(admin) and sub user concept in hive yet, but the community is having plans to implement that in future with strong Authorization mechanisms.
Saying this if the business users are guaranteed not to play with GRANT statements or rather not change permissions themselves, (But it is hard to guarantee this when the no of users are large :) ) hive can satisfy your requirement.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: "Raghunath, Ranjith" <[EMAIL PROTECTED]>
Date: Sat, 19 May 2012 00:54:36
To: [EMAIL PROTECTED]<[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: RE: Is there a way to create user account and grant read only
 permissions?

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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB