hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benyi Wang (Created) (JIRA)" <>
Subject [jira] [Created] (HIVE-2817) Drop any table even without privilege
Date Thu, 23 Feb 2012 23:39:49 GMT
Drop any table even without privilege

                 Key: HIVE-2817
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.7.1
            Reporter: Benyi Wang

You can drop any table if you use fully qualified name 'database.table' even you don't have
any previlige.

hive> set;
hive> revoke all on default from user test_user;
hive> drop table abc;
hive> drop table abc;
Authorization failed:No privilege 'Drop' found for outputs { database:default, table:abc}.
Use show grant to get more details.
hive> drop table;
Time taken: 0.13 seconds

The table and the file in {{/usr/hive/warehouse}} or external file will be deleted. If you
don't have hadoop access permission on {{/usr/hive/warehouse}} or external files, you will
see a hadoop access error

12/02/23 15:35:35 ERROR hive.log:
Permission denied: user=test_user, access=WRITE, inode="/user/myetl":myetl:etl:drwxr-xr-x
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message