[TRAFODION-2188] Insufficient privileges on sample table error message from an Update Statistics operation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-security
• Assignee: Roberta Marton
• Reporter: Roberta Marton
• Created: 25/Aug/16 22:04
• Updated: 13/Sep/16 23:58
• Resolved: 13/Sep/16 23:58

Description

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.
      .