Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15483

Database and table name is case sensitive when used in show grant

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      Description

      When use SQLStdAuth, db name and table name is case sensitive when use show grant command.

      0: jdbc:hive2://localhost:21066/> show grant on table p1;
      +-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
      | database  | table  | partition  | column  |    principal_name    | principal_type  | privilege  | grant_option  |   grant_time   | grantor  |
      +-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
      | default   | p1     |            |         | userx                | USER            | DELETE     | true          | 1481872357000  | userx    |
      | default   | p1     |            |         | userx                | USER            | INSERT     | true          | 1481872357000  | userx    |
      | default   | p1     |            |         | userx                | USER            | SELECT     | true          | 1481872357000  | userx    |
      | default   | p1     |            |         | userx                | USER            | UPDATE     | true          | 1481872357000  | userx    |
      +-----------+--------+------------+---------+----------------------+-----------------+------------+---------------+----------------+----------+--+
      7 rows selected (0.158 seconds)
      
      0: jdbc:hive2://localhost:21066/> show grant on table P1;
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      | database  | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  | grant_time  | grantor  |
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      No rows selected (9.608 seconds)
      0: jdbc:hive2://localhost:21066/> show grant on table defaulT.p1;
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      | database  | table  | partition  | column  | principal_name  | principal_type  | privilege  | grant_option  | grant_time  | grantor  |
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------+----------+--+
      No rows selected (0.06 seconds)
      

        Attachments

        1. HIVE-15483.1.patch
          1 kB
          Niklaus Xiao

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              niklaus.xiao Niklaus Xiao Assign to me
              Reporter:
              niklaus.xiao Niklaus Xiao

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment