[
https://issues.apache.org/jira/browse/HIVE-27195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742770#comment-17742770
]
Stamatis Zampetakis edited comment on HIVE-27195 at 7/13/23 11:37 AM:
----------------------------------------------------------------------
[~rtrivedi12]Please enrich the description of this ticket with what should be
the expected behavior after the changes in the PR. The reference to HIVE-20051
is a bit misleading since someone may believe that temporary tables will not be
authorized while in practice the PR does the opposite and enforces
authorization also at the database level.
was (Author: zabetak):
[~rtrivedi12]Please enrich the description of this ticket with what should be
the expected behavior after the changes in the PR. The reference to HIVE-200051
is a bit misleading since someone may believe that temporary tables will not be
authorized while in practice the PR does the opposite and enforces
authorization also at the database level.
> Drop table if Exists <database>.<tablename> fails during authorization for
> temporary tables
> -------------------------------------------------------------------------------------------
>
> Key: HIVE-27195
> URL: https://issues.apache.org/jira/browse/HIVE-27195
> Project: Hive
> Issue Type: Bug
> Reporter: Riju Trivedi
> Assignee: Riju Trivedi
> Priority: Major
> Labels: pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> https://issues.apache.org/jira/browse/HIVE-20051 handles skipping
> authorization for temporary tables. But still, the drop table if Exists fails
> with HiveAccessControlException.
> Steps to Repro:
> {code:java}
> use test; CREATE TEMPORARY TABLE temp_table (id int);
> drop table if exists test.temp_table;
> Error: Error while compiling statement: FAILED: HiveAccessControlException
> Permission denied: user [rtrivedi] does not have [DROP] privilege on
> [test/temp_table] (state=42000,code=40000) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
