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

Implement show grant on <resource>

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.13.0
    • Authorization

    Description

      Currently, hive shows privileges owned by a principal. Reverse API is also needed, which shows all principals for a resource. 

      show grant user hive_test_user on database default;
show grant user hive_test_user on table dummy;
show grant user hive_test_user on all;

      Attachments

        1. HIVE-6122.6.patch
          79 kB
          Ashutosh Chauhan
        2. HIVE-6122.5.patch
          79 kB
          Ashutosh Chauhan
        3. HIVE-6122.4.patch
          77 kB
          Ashutosh Chauhan
        4. HIVE-6122.4.patch
          77 kB
          Ashutosh Chauhan
        5. HIVE-6122.3.patch.txt
          80 kB
          Navis Ryu
        6. HIVE-6122.2.patch.txt
          67 kB
          Navis Ryu
        7. HIVE-6122.1.patch.txt
          66 kB
          Navis Ryu

        Issue Links

        blocks

        Bug - A problem which impairs or prevents the functions of the product. HIVE-6203 Privileges of role granted indrectily to user is not applied

        • Major - Major loss of function.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-6204 The result of show grant / show role should be tabular format

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved
        is blocked by

        Bug - A problem which impairs or prevents the functions of the product. HIVE-5414 The result of show grant is not visible via JDBC

        • Trivial - Cosmetic problem like misspelt words or misaligned text.
        • Resolved
        relates to

        Sub-task - The sub-task of the issue HIVE-5933 SQL std auth - add support to metastore api to list all privileges for a user

        • 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
        links to

        Web Link review board

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            navis Navis Ryu Assign to me
            navis Navis Ryu
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment