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
>
