[
https://issues.apache.org/jira/browse/TRAFODION-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roberta Marton closed TRAFODION-2641.
-------------------------------------
Resolution: Fixed
changes have been delivered.
> 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.4.14#64029)
