Permissions for Apache 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 |