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 |