Page tree
Skip to end of metadata
Go to start of metadata
ActionSelectUpdateCreateDropAlterIndexLockAllURI RWX permissionComments 
CREATE TABLE  X    XX -for create external table – the location)  
DROP TABLE   X   X   
DESCRIBE TABLEX      X   
SHOW PARTITIONSX      X   
ALTER TABLE LOCATION    X  XX - for new location  
ALTER PARTITION LOCATION    X  XX - for new partition location  
ALTER TABLE ADD PARTITION    X  XX - for partition location  
ALTER TABLE DROP PARTITION    X  X   
ALTER TABLE (all of them except the ones above)    X  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   
ANALYZE TABLEX      X   
SHOW DATABASESX      X   
SHOW COLUMNSX      X   
SHOW TABLE STATUSX      X   
SHOW TABLE PROPERTIESX      X   
CREATE TABLE AS SELECTX X    X   
CREATE INDEX  X  X X   
DROP INDEX   X X X   
ALTER INDEX REBUILD    XX X   
ALTER INDEX PROPERTIES    XX X   
LOCK DB      XX   
UNLOCK DB      XX   
LOCK TABLE      XX   
UNLOCK TABLE      XX   
SELECTX      X   
INSERT X     X   
UPDATE X     X   
DELETE X     X   
LOADX      XX- input location  
SHOW CREATE TABLEX      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   
IMPORTX X    X   
EXPORTXX     X   
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 

 

 

 

  • No labels