you can hack the meta database,eg create a triger on the TBLS which do some check and return error when delete from this table
jov 在 2013-11-23 上午3:36,"Echo Li" <echo...@gmail.com>写道: > 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 >