Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-2395

ALTER VIEW AS SELECT is asking for CREATE privileges instead of ALTER

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.0
    • Component/s: Sentry
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                spena Sergio Peña
                Reporter:
                spena Sergio Peña
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: