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] [Updated] (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 updated SENTRY-2395:
--------------------------------
Attachment: SENTRY-2395.1.patch
> 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)