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.

Table 1. Required Minimum Permissions for Hive Operations

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