Child pages
  • SQL Standard Based Hive Authorization

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Follow-up for HIVE-12408.

...

Action
Select
Insert
Update
Delete
Ownership
Admin
URI Privilege (RWX Permission + Ownership)
CREATE TABLE    Y (of database) Y  (for create external table – the location)
DROP TABLE    Y  
DESCRIBE TABLEY      
SHOW PARTITIONSY      
ALTER TABLE LOCATION    Y Y (for new location)
ALTER PARTITION LOCATION    Y Y (for new partition location)
ALTER TABLE ADD PARTITION Y    Y (for partition location)
ALTER TABLE DROP PARTITION   Y   
ALTER TABLE (all of them except the ones above)    Y  
TRUNCATE TABLE    Y  
CREATE VIEWY + G      
ALTER VIEW PROPERTIES    Y  
ALTER VIEW RENAME    Y  
DROP VIEW PROPERTIES    Y  
DROP VIEW    Y  
ANALYZE TABLEYY     
SHOW COLUMNSY      
SHOW TABLE STATUSY      
SHOW TABLE PROPERTIESY      
CREATE TABLE AS SELECTY (of input)   Y (of database)  
CREATE INDEX    Y (of table)  
DROP INDEX    Y  
ALTER INDEX REBUILD    Y  
ALTER INDEX PROPERTIES    Y  
SELECTY      
INSERT Y Y (for OVERWRITE)   
UPDATE  Y    
DELETE   Y   
LOAD Y (output) Y (output)  Y (input location)
SHOW CREATE TABLEY+G      
CREATE FUNCTION     Y 
DROP FUNCTION     Y 
CREATE MACRO     Y 
DROP MACRO     Y 
MSCK (metastore check)     Y 
ALTER DATABASE     Y 
CREATE DATABASE      Y (if custom location specified)
EXPLAINY      
DROP DATABASE    Y  
Info
titleVersion Information

As of Hive 3.0.0 (HIVE-12408), Ownership is not required for the URI Privilege.


Configuration

For Hive 0.13.x

...