You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2018/09/07 20:25:00 UTC

[jira] [Commented] (SENTRY-2395) ALTER VIEW AS SELECT is asking for CREATE privileges instead of ALTER

    [ https://issues.apache.org/jira/browse/SENTRY-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16607620#comment-16607620 ] 

Hadoop QA commented on SENTRY-2395:
-----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12938851/SENTRY-2395.1.patch against master.

{color:green}Overall:{color} +1 all checks pass

{color:green}SUCCESS:{color} all tests passed

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/4089/console

This message is automatically generated.

> ALTER VIEW AS SELECT is asking for CREATE privileges instead of ALTER
> ---------------------------------------------------------------------
>
>                 Key: SENTRY-2395
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2395
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>            Reporter: Sergio Peña
>            Assignee: Sergio Peña
>            Priority: Major
>         Attachments: SENTRY-2395.1.patch
>
>
> When executing the command {{ALTER VIEW <view> AS SELECT <columns> FROM <table>}}  is asking for CREATE privileges in the database where the view exists.
> ALTER VIEW AS SELECT should not require CREATE privileges because it is only changing the metadata of the view to use a different table or schema. Instead, it should require ALTER on the view and SELECT on the table.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)