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 | | | | | | | | | 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 | | | | | | | X | X- input location | | |
SHOW CREATE TABLE | X | | | | | | | X | | | |
CREATE FUNCTION | | | X | | | | | X | | | |
DROP FUNCTION | | | | X | | | | X | | | |
MSCK (metastore check) | | | | | | | | X | | Will be addressed by Hive in Erie-M20 | |
ALTER DATABASE | | | | | X | | | X | | | |
CREATE DATABASE | | | X | | | | | X | | | |
DROP DATABASE | | | | X | | | | X | | | |
IMPORT | X | | X | | | | | X | | | |
EXPORT | X | X | | | | | | X | | | |
GRANT | | | | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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- input location |
|
|
SHOW CREATE TABLE | X |
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|
CREATE FUNCTION |
|
|
|
|
|
|
|
|
|
| X |
|
|
|
|
|
DROP FUNCTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
MSCK (metastore check) |
|
|
|
| X | X |
|
|
|
|
|
|
|
|
|
|
ALTER DATABASE |
|
|
|
| X | X |
|
|
|
|
|
|
|
|
|
|
CREATE DATABASE |
|
| X |
|
| X |
|
|
|
|
|
|
|
|
|
|
DROP DATABASE |
|
|
| X |
| X |
|
|
|
|
|
|
|
|
|
|
IMPORT |
|
| X |
|
| X |
|
|
|
|
|
|
|
|
|
|
EXPORT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GRANT |
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 | |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Not Supported in Ranger |
|
RESET |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
SET |
RESET | | | | | | | | | | No Ranger Auth | |
SET | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | No Ranger Auth | | ...