Roberta Marton created TRAFODION-2641:
-----------------------------------------
Summary: User who has MANAGE_STATISTICS privilege can't do update
statistics on HIVE tables
Key: TRAFODION-2641
URL: https://issues.apache.org/jira/browse/TRAFODION-2641
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Roberta Marton
Assignee: Roberta Marton
Currently a non DB__ROOT user granted MANAGE_STATISTICS privilege on a hive
table fails with error 2017 - no privilege.
To reproduce:
as DB__ROOT:
unregister hive table hive.hive.item;
grant component privilege "MANAGE" on sql_operations to sql_user1;
As sql_user1:
update statistics for table hive.hive.item on every column;
*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.ITEM encountered an error
(1017) from statement register hive table.
*** ERROR[1017] You are not authorized to perform this operation.
*** ERROR[8839] Transaction was aborted.
*** ERROR[4082] Object HIVE.HIVE.ITEM does not exist or is inaccessible.
--- SQL operation failed with errors.
update statistics for table hive.hive.item on every column;
*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.ITEM encountered an error
(1017) from statement register hive table.
*** ERROR[1017] You are not authorized to perform this operation.
*** ERROR[8839] Transaction was aborted.
*** ERROR[4082] Object HIVE.HIVE.ITEM does not exist or is inaccessible.
--- SQL operation failed with errors.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
