Mahesh Bandal created RANGER-5097:
-------------------------------------

             Summary: Fix setOwnerUser function to ensure the Hive default 
{owner} policy works correctly
                 Key: RANGER-5097
                 URL: https://issues.apache.org/jira/browse/RANGER-5097
             Project: Ranger
          Issue Type: Bug
          Components: Ranger
    Affects Versions: 3.0.0
            Reporter: Mahesh Bandal
            Assignee: Mahesh Bandal


Create a Hive Table as spark user from beeline and then try accessing the same 
table from spark3-shell. The select query on Hive Table fails.
{noformat}
create table spark_table_123 (name string);
select * from spark_table_123
{noformat}

The below error is observed in spark3-shell
{noformat}
org.apache.spark.sql.AnalysisException: 
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table 
spark_table_123. Permission denied: user [spark] does not have [SELECT] 
privilege on [default/spark_table_123]
{noformat}

Expectation:
The Hive default policy for "Owner" user allowing "all" Access on all Hive 
Database, table & column should allow the access.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to