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 |