Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5837 SQL standard based secure authorization for hive
  3. HIVE-5923

SQL std auth - parser changes

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • Authorization
    • None
    • Hide
      Grant privilege and revoke privilege statements don't have the requirement (but not the option) for the noise word TABLE.
       TABLE is the assumed default for grant and revoke statements.
      Hive’s syntax changes from "GRANT action ON TABLE table TO grantee" to "GRANT action ON [TABLE] table TO grantee".

      Grant role and revoke role statements has been changed to remove the need for keyword ROLE.

      Support for WITH ADMIN OPTION has been added to grant role and revoke role statement syntax.
      Show
      Grant privilege and revoke privilege statements don't have the requirement (but not the option) for the noise word TABLE.  TABLE is the assumed default for grant and revoke statements. Hive’s syntax changes from "GRANT action ON TABLE table TO grantee" to "GRANT action ON [TABLE] table TO grantee". Grant role and revoke role statements has been changed to remove the need for keyword ROLE. Support for WITH ADMIN OPTION has been added to grant role and revoke role statement syntax.

    Description

      There are new access control statements proposed in the functional spec in HIVE-5837 . It also proposes some small changes to the existing query syntax (mostly extensions and some optional keywords).

      The syntax supported should depend on the current authorization mode.

      Attachments

        1. HIVE-5923.4.patch
          21 kB
          Thejas Nair
        2. HIVE-5923.3.patch
          21 kB
          Thejas Nair
        3. HIVE-5923.2.patch
          13 kB
          Thejas Nair
        4. HIVE-5923.1.patch
          13 kB
          Thejas Nair

        Issue Links

          blocks

          Sub-task - The sub-task of the issue HIVE-5930 SQL std auth - implement set roles, show current roles

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-5940 SQL std auth - support,authorize new 'show grant..' statements

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue HIVE-5942 SQL std auth - support DESCRIBE ROLE

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link reviewboard link

          Activity

            People

              thejas Thejas Nair
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 96h Original Estimate - 96h
                  96h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 168h
                  168h