You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2016/09/13 23:58:20 UTC
[jira] [Commented] (TRAFODION-2188) Insufficient privileges on
sample table error message from an Update Statistics operation
[ https://issues.apache.org/jira/browse/TRAFODION-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15488871#comment-15488871 ]
Roberta Marton commented on TRAFODION-2188:
-------------------------------------------
The problem of now allowing the sample table to be created has been fixed.
In addition, you now can update statistics if you SELECT privilege on the table.
> Insufficient privileges on sample table error message from an Update Statistics operation
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-2188
> URL: https://issues.apache.org/jira/browse/TRAFODION-2188
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-security
> Reporter: Roberta Marton
> Assignee: Roberta Marton
>
> According to documentation, to update stats, you must:
> -- be DB__ROOT
> -- be table owner
> -- have the MANAGE_STATISTICS privilege (DB__ROOTROLE has priv)
> sql_user3 has MANAGE_STATISTICS privilege but still gets insufficient privs error - only if the table has enough rows to create a sample table and table exists in a private schema:
> As db__root create a private schema, table t132t3 and load data.
> grant component privilege MANAGE_STATISTICS on sql_operations to sql_user3;
> As sql_user3 - update statistics for table t132t3 create sample random 10 percent;
> *** ERROR[9214] Object TRAFODION.T132SCH_PRIVATE.TRAF_SAMPLE_78_1472162288_609978 could not be created.
> *** ERROR[1017] You are not authorized to perform this operation.
> .
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)