hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Hive in a readonly mode
Date Wed, 30 Mar 2011 14:40:55 GMT
On Wed, Mar 30, 2011 at 9:29 AM, Guy Doulberg <Guy.Doulberg@conduit.com> wrote:
> Hey all,
>
> I bet someone has already asked this question before, but I couldn't a
> thread with an answer to it,
>
>
>
> I want to give analysts in my organization access to hive in a readonly way,
>
> I.E, I don't want them to be able to create, drop tables, Alter tables ,
> insert or load.
>
>
>
> How can I do that?
>
>
>
> Thanks, anyway
>
>
>
>
>
>

Hive 0.7.0 has grant/revoke syntax.

If you are looking for a simple solution in a pre "hadoop security"
world: Recursively  own /user/hive/warehouse by a user different then
the user running queries and enable dfs.permissions. This should
prevent anyone from writing to the files. Although jobs running and
failing will be less then optimal. After a few failures hopefully
users will get the point.

Mime
View raw message