...
Action | Select | Insert | Delete | Ownership | Admin | URI Privilege (RWX Permission + Ownership) |
---|---|---|---|---|---|---|
CREATE TABLE | Y (of database) | Y (for create external table – the location) | ||||
DROP TABLE | Y | |||||
DESCRIBE TABLE | Y | |||||
SHOW PARTITIONS | Y | |||||
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 VIEW | Y + G | |||||
ALTER VIEW PROPERTIES | Y | |||||
ALTER VIEW RENAME | Y | |||||
DROP VIEW PROPERTIES | Y | |||||
DROP VIEW | Y | |||||
ANALYZE TABLE | Y | Y | ||||
SHOW COLUMNS | Y | |||||
SHOW TABLE STATUS | Y | |||||
SHOW TABLE PROPERTIES | Y | |||||
CREATE TABLE AS SELECT | Y (of input) | Y (of database) | ||||
CREATE INDEX | Y (of table) | |||||
DROP INDEX | Y | |||||
ALTER INDEX REBUILD | Y | |||||
ALTER INDEX PROPERTIES | Y | |||||
QUERY (insert, select queries) | Y (input) | Y (output) | Y (output) | |||
LOAD | Y (output) | Y (output) | Y (input location) | |||
SHOW CREATE TABLE | Y+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) | |||||
EXPLAIN | Y | |||||
DROP DATABASE | Y |
...