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

Hive revoke the grant err by hive.security.authorization.createtable.role.grants ( SQL Standard Based Hive Authorization )

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.5
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      Description

      1. Start hiveserver2

      >/opt/hive/hive-bin/bin/hiveserver2 --hiveconf hive.server2.thrift.port=50033 --hiveconf hive.server2.webui.port=10003

      2. create table

      #/opt/hive/hive-bin/bin/beeline -u jdbc:hive2://172.31.10.119:50033 -n tools

      >use tools;

      >create table test1 as select * from tools.test99 limit 10;

      >show grant on table tools.test1;

      ----------------------+-----------------------------------------------------------------------------------------------------

      database      table     partition  column  principal_name  principal_type  privilege  grant_option     grant_time   grantor 

      ----------------------+-----------------------------------------------------------------------------------------------------

      tools     test1                       da        ROLE            SELECT     true          1565061852000  tools   

      ----------------------+-----------------------------------------------------------------------------------------------------

       

      3. revoke select on role da

      > set role damin;

      > revoke select on table tools.test1 from role da;

      4. err log

      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot find privilege Privilege [name=SELECT, columns=null] for Principal [name=da, type=ROLE] on Object [type=TABLE_OR_VIEW, name=tools.test1] granted by tools

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhangxin0112zx xinzhang
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: