[ https://issues.apache.org/jira/browse/RANGER-5097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Raghav Aggarwal updated RANGER-5097: ------------------------------------ Attachment: (was: create_db_HS2_stacktrace.txt) > 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 > Priority: Major > Attachments: create_db_HS2_stacktrace.txt, > create_table_HS2_stacktrace.txt > > > 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)