ActionSelectUpdateCreateDropAlterAllReadWriteReplAdminServiceAdmin

Temporary UDF admin

RefreshRW StorageURI RWX permissionComments
CREATE TABLE

X

X






X -for create external table – the location)

DROP TABLE


X
X









DESCRIBE TABLEX



X









SHOW PARTITIONSX



X









ALTER TABLE LOCATION



XX






X - for new location

ALTER PARTITION LOCATION



X







X - for new partition location

ALTER TABLE ADD PARTITIONX


X







X - for partition location

ALTER TABLE DROP PARTITION



X










ALTER TABLE (all of them except the ones above)



X










TRUNCATE TABLE
X


X









CREATE VIEW

X

X









ALTER VIEW PROPERTIES



XX









ALTER VIEW RENAME



XX









DROP VIEW PROPERTIES


X
X









DROP VIEW


X
X









ANALYSE TABLEX



X









SHOW DATABASESXXXXXXXXXXXXX


SHOW COLUMNSX



X









CREATE TABLE AS SELECTX
X












SELECTX



X









INSERT
X


X









UPDATE
X


X









DELETEXX


X









LOAD
X


X






X- input location

SHOW CREATE TABLEX



X









CREATE FUNCTION









X




DROP FUNCTION















MSCK (metastore check)



XX









ALTER DATABASE



XX









CREATE DATABASE

X

X









DROP DATABASE


X
X









IMPORT

X

X









EXPORT















GRANT













In Ranger - User should be "ADMIN"
REVOKE













In Ranger - User should be "ADMIN"
SHOW GRANT













Not Supported
CREATE ROLE













Not Supported
DROP ROLE













Not Supported
SHOW CURRENT ROLES













Not Supported
REVOKE ROLE













Not Supported
GRANT ROLE













Not Supported
SHOW ROLE













Not Supported
SHOW ROLE GRANT













Not Supported
SHOW PRINCIPALS













Not Supported
SHOW CONF













No Ranger Auth
LIST FILE[S] , LIST JAR[S], LIST ARCHIVE[S]













No Ranger Auth
ADD FILE[S] , ADD JAR[S], ADD ARCHIVE[S]













No Ranger Auth
DELETE FILE[S] , DELETE JAR[S] , DELETE ARCHIVE[S]













No Ranger Auth
COMPILE













No Ranger Auth
DFS













Not Supported in Ranger
RESET













No Ranger Auth
SET













No Ranger Auth
SHOW FUNCTION













No Ranger Auth
DESCRIBE FUNCTION













No Ranger Auth
DROP MACRO













No Ranger Auth
CREATE MACRO













No Ranger Auth
SHOW LOCKS













No Ranger Auth
SHOW TRANSACTIONS













No Ranger Auth
EXPLAIN













No Ranger Auth
case REPLDUMP







X






case REPLSTATUS







X






RWSTORAGE











X


Read data from HDFS using hdfs




X












  • No labels