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)