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