6. Required Permissions for Hive Operations

The following table shows the minimum permissions required for Hive operations using storage-based authorization:

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