Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2641

User who has MANAGE_STATISTICS privilege can't do update statistics on HIVE tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • None
    • sql-security
    • None

    Description

      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.

      Attachments

        Activity

          People

            rmarton Roberta Marton
            rmarton Roberta Marton
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: