By default, Hive in HDP uses HCatalog's storage-based authorization model instead of the basic Hive authorization model. Storage-based authorization manages access with file permissions, and the HiveQL statements GRANT and REVOKE have no effect. See Metastore Server Security in Hive Authorization and the HCatalog document Storage Based Authorization for more information.
