Storage-based operation permissions
If you use SBA, you need to know which Hive operations have read and write access to your Hive databases and tables.
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 |