Action | Select | Update | Create | Drop | Alter |
Index | Lock | All | Read | Write | ReplAdmin | ServiceAdmin | Temporary UDF admin | Refresh | RW Storage |
All | URI RWX permission | Comments |
| | | | | |
|
| X |
|
|
|
|
|
|
| X -for create external table – the location) |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | X |
|
|
|
|
|
|
| X - for new partition location |
| |
|
|
ALTER TABLE ADD PARTITION |
| | | | | | X |
|
|
|
|
|
|
| X - for partition location |
| |
|
|
ALTER TABLE DROP PARTITION |
| | | | | | | |
|
|
|
|
|
|
|
|
|
|
ALTER TABLE (all of them except the ones above) |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ANALYZE TABLE | X | | | | | | | X | | | |
SHOW COLUMNS | X | | | | | | | X | | | |
SHOW TABLE STATUS | X | | | | | | | X | | | |
SHOW TABLE PROPERTIES | X | | | | | | | X | | | |
CREATE TABLE AS SELECT | X | | X | | | | | X | | | |
CREATE INDEX | | | X | | | X | | X | | | |
DROP INDEX | | | | X | | X | | X | | | |
ALTER INDEX REBUILD | | | | | X | X | | X | | | |
ALTER INDEX PROPERTIES | | | | | X | X | | X | | | |
LOCK DB | | | | | | | X | X | | | |
UNLOCK DB | | | | | | | X | X | | | |
LOCK TABLE | | | | | | | X | X | | | |
UNLOCK TABLE | | | | | | | X | X | | | |
SELECT | X | | | | | | | X | | | |
INSERT | | X | | | | | | X | | | |
UPDATE | | X | | | | | | X | | | |
DELETE | | X | | | | | | X | | | |
LOAD | X | | | | | |
|
|
|
|
|
|
|
|
|
|
ANALYSE TABLE | X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SHOW DATABASES | X | X | X | X | X | X | X | X | X | X | X | X | X |
|
|
|
SHOW COLUMNS | X |
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|
CREATE TABLE AS SELECT | X |
| X |
|
|
|
|
|
|
|
|
|
|
|
|
|
SELECT | X |
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|
INSERT |
| X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
UPDATE |
| X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
DELETE | X | X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
LOAD |
| X |
| | | | | | | | | | | | | | | X | | | | | | | X | | | | X | | | | | | | | | | X | | Will be addressed by Hive in Erie-M20 | | | | | | | | | | | | | | | | | | | | | | | X | | | | | | | X | X | | | | | X | | | | | | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
| In Ranger - User should be "ADMIN" |
| | | | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
| In Ranger - User should be "ADMIN" |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
LIST FILE[S] , LIST JAR[S], LIST ARCHIVE[S] |
| | | | | | | | |
|
ADD FILE[S] , ADD JAR[S], ADD ARCHIVE[S] |
| | | | | | | | |
|
DELETE FILE[S] , DELETE JAR[S] , DELETE ARCHIVE[S] |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | No Ranger Auth | |
...
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
case REPLDUMP |
|
|
|
|
|
|
|
| X |
|
|
|
|
|
|
|
case REPLSTATUS |
|
|
|
|
|
|
|
| X |
|
|
|
|
|
|
|
RWSTORAGE |
|
|
|
|
|
|
|
|
|
|
|
| X |
|
|
|
Read data from HDFS using hdfs |
|
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|