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 |
|
|
|
