Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-7059

Inconsistent privilege model between DESCRIBE and DESCRIBE DATABASE

    XMLWordPrintableJSON

Details

    • ghx-label-8

    Description

      [localhost:21000] default> grant insert on database functional to role foo_role;                                                                                                                                                             
      Query: grant insert on database functional to role foo_role
      Query submitted at: 2018-07-11 11:05:51 (Coordinator: http://fwijaya-impala-dev3.vpc.cloudera.com:25000)
      Query progress can be monitored at: http://fwijaya-impala-dev3.vpc.cloudera.com:25000/query_plan?query_id=4a45c33de497d745:8242abc400000000
      +---------------------------------+
      | summary                         |
      +---------------------------------+
      | Privilege(s) have been granted. |
      +---------------------------------+
      Fetched 1 row(s) in 0.13s
      [localhost:21000] default> describe functional.alltypes;
      Query: describe functional.alltypes
      Fetched 0 row(s) in 5.45s
      
      [localhost:21000] default> describe database functional;
      Query: describe database functional
      +------------+-----------------------------------------------------+---------+
      | name       | location                                            | comment |
      +------------+-----------------------------------------------------+---------+
      | functional | hdfs://localhost:20500/test-warehouse/functional.db |         |
      +------------+-----------------------------------------------------+---------+
      

      For consistency with privileges on other metadata SQL statements, such as DESCRIBE DATABASE, we should register VIEW_METADATA privilege instead of just SELECT.

      Attachments

        Activity

          People

            fredyw Fredy Wijaya
            fredyw Fredy Wijaya
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: