Storage-based operation permissions

Table 1. Required Minimum Permissions for Hive Operations

Operation

Database READ Access

Database WRITE Access

Table READ Access

Table WRITE Access

LOAD

X

EXPORT

X

IMPORT

X

CREATE TABLE

X

CREATE TABLE AS SELECT

X

X (source table)

DROP TABLE

X

SELECT

X

ALTER TABLE

X

SHOW TABLES

X