You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@sentry.apache.org by "Sergio Peña (JIRA)" <ji...@apache.org> on 2018/09/07 16:46:00 UTC

[jira] [Assigned] (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:all-tabpanel ]

Sergio Peña reassigned SENTRY-2395:
-----------------------------------

    Assignee: Sergio Peña

> 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)