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

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

    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

            People

            • Assignee:
              niklaus.xiao Niklaus Xiao
              Reporter:
              niklaus.xiao Niklaus Xiao
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: