Storage-based operation permissions

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