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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.1.0
    • Sentry
    • 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

        1. SENTRY-2395.1.patch
          9 kB
          Sergio Peña

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: