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 >> How to prevent user drop table in Hive metadata?


Copy link to this message
-
Re: How to prevent user drop table in Hive metadata?
You can use: ALTER TABLE {table_name} ENABLE NO_DROP;

And it will keep a user from dropping the table - but it can be over ridden.

Rick
On Nov 22, 2013 12:36 PM, "Echo Li" <[EMAIL PROTECTED]> wrote:

> Good Friday!
>
> I was trying to apply certain level of security in our hive data
> warehouse, by modifying access mode of directories and files on hdfs to 755
> I think it's good enough for a new user to remove data, however the user
> still can drop the table definition in hive cli, seems the "revoke" doesn't
> help much, is there any way to prevent this?
>
>
> Thanks,
> Echo
>
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