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

The grant all operation is not dropping the create/alter/drop/index/lock privileges.

    Details

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

      Description

      When an object has the ALL privilege, any individual privilege explicitly granted (i.e. create, select, insert, ...) after that has no effect on the privilege list because ALL implies the role or user has all those privileges.

      However, when any of the new privileges list (create, alter, drop) is granted before, and then the grant ALL happens, those privileges are not removed. We should keep the GRANT ALL consistent and remove any individual privilege (except the OWNER privilege) from the list. 

        Attachments

        1. SENTRY-2315.1.patch
          8 kB
          Sergio Peña
        2. SENTRY-2315.2.patch
          8 kB
          Sergio Peña

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: