sentry-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Peña (JIRA) <j...@apache.org>
Subject [jira] [Updated] (SENTRY-2395) ALTER VIEW AS SELECT is asking for CREATE privileges instead of ALTER
Date Mon, 10 Sep 2018 19:21:00 GMT

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

Sergio Peña updated SENTRY-2395:
--------------------------------
       Resolution: Fixed
    Fix Version/s: 2.1.0
           Status: Resolved  (was: Patch Available)

> 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
>             Fix For: 2.1.0
>
>         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)

Mime
View raw message