[jira] [Work started] (TRAFODION-2641) User who has MANAGE_STATISTICS privilege can't do update statistics on HIVE tables

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TRAFODION-2641 started by Roberta Marton.
-------------------------------------------------
> 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)