You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "László Pintér (Jira)" <ji...@apache.org> on 2020/04/20 08:00:00 UTC

[jira] [Resolved] (HIVE-22586) Temporary table delete fails with "SemanticException No valid privileges"

     [ https://issues.apache.org/jira/browse/HIVE-22586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

László Pintér resolved HIVE-22586.
----------------------------------
    Resolution: Duplicate

> Temporary table delete fails with "SemanticException No valid privileges"
> -------------------------------------------------------------------------
>
>                 Key: HIVE-22586
>                 URL: https://issues.apache.org/jira/browse/HIVE-22586
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: László Pintér
>            Assignee: László Pintér
>            Priority: Major
>
> When using Hive with Sentry, at the moment is not possible to delete a temporary tables without granting ALL privileges on database/table level.
> Temporary tables are strongly bound to the session, and it is only visible/accessible to the user who owns the session, and the table exists until the session is not closed. 
> Since temporary tables only exists on session level, and they are not connected to any database, checking the privileges with Sentry is unnecessary. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)