Uploaded image for project: '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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: