Hive
  1. Hive
  2. HIVE-1928

GRANT/REVOKE should handle privileges as tokens, not identifiers

    Details

    • Hadoop Flags:
      Reviewed

      Description

      The grammar for the GRANT and REVOKE Privileges statements currently handle the list of privileges as a list of
      identifiers. Since most of the privileges are also keywords in the HQL grammar this requires users
      to individually quote-escape each of the privileges, e.g:

      grant `Create` on table authorization_part to user hive_test_user;
      grant `Update` on table authorization_part to user hive_test_user;
      grant `Drop` on table authorization_part to user hive_test_user;
      grant `select` on table src to user hive_test_user;
      

      Both MySQL and the SQL standard treat privileges as tokens. Hive should do the same.

      1. HIVE-1928.1.patch
        76 kB
        Jonathan Natkins
      2. HIVE-1928.2.patch
        78 kB
        Jonathan Natkins

        Issue Links

          Activity

          Carl Steinbach created issue -
          Carl Steinbach made changes -
          Field Original Value New Value
          Link This issue is related to HIVE-78 [ HIVE-78 ]
          Carl Steinbach made changes -
          Fix Version/s 0.7.0 [ 12315150 ]
          Carl Steinbach made changes -
          Priority Blocker [ 1 ] Critical [ 2 ]
          Carl Steinbach made changes -
          Fix Version/s 0.7.0 [ 12315150 ]
          Jonathan Natkins made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Assignee Jonathan Natkins [ natty ]
          Jonathan Natkins made changes -
          Attachment HIVE-1928.1.patch [ 12471205 ]
          Jonathan Natkins made changes -
          Attachment HIVE-1928.2.patch [ 12471236 ]
          Carl Steinbach made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Fix Version/s 0.7.0 [ 12315150 ]
          Resolution Fixed [ 1 ]
          Carl Steinbach made changes -
          Labels Authorization
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Carl Steinbach made changes -
          Component/s Authorization [ 12317300 ]
          Component/s Query Processor [ 12312586 ]

            People

            • Assignee:
              Jonathan Natkins
              Reporter:
              Carl Steinbach
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development