You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

ActionSelectUpdateCreateDropAlterLockAllReadWriteReplAdminServiceAdmin

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



X
X






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



X
X









ALTER VIEW RENAME



X
X









DROP VIEW PROPERTIES


X

X









DROP VIEW


X

X









ANALYSE TABLEX




X









SHOW DATABASESXXXXXXXXXXXXXX


SHOW COLUMNSX




X









SHOW TABLE STATUS
















SHOW TABLE PROPERTIES
















CREATE TABLE AS SELECTX
X













CREATE INDEX
















DROP INDEX
















ALTER INDEX REBUILD
















ALTER INDEX PROPERTIES
















LOCK DB
















UNLOCK DB
















LOCK TABLE
















UNLOCK TABLE
















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)



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"
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