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

GRANT/REVOKE should handle privileges as tokens, not identifiers

    XMLWordPrintableJSON

Details

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

      Attachments

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

        Issue Links

          Activity

            People

              natty Jonathan Natkins
              cwsteinbach Carl Steinbach
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: