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

Table Rename Cross Database should update permission correctly

    XMLWordPrintableJSON

    Details

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

      Description

      Right now, when renaming a table, if the database changes, the privileges will be moved to the wrong table.

      For example, original table is db1.tbl1, and user changes to db2.tbl2 using command 
      ALTER TABLE [old_db_name.]old_table_name RENAME TO [new_db_name.]new_table_name

      Expected behavior:
      The privileges associated with db1.tbl1 should be removed from db1.tbl1, and added to db2.tbl2.

      Actual behavior:
      The privileges associated with db1.tbl1 is removed from db1.tbl1, and added to db1.tbl2.

        Attachments

        1. SENTRY-2144.001.patch
          5 kB
          Na Li
        2. SENTRY-2144.002.patch
          11 kB
          Na Li
        3. SENTRY-2144.003.patch
          15 kB
          Na Li
        4. SENTRY-2144.004.patch
          17 kB
          Na Li
        5. SENTRY-2144.006.patch
          5 kB
          Na Li
        6. SENTRY-2144.006.patch
          5 kB
          Na Li

          Issue Links

            Activity

              People

              • Assignee:
                linaataustin Na Li
                Reporter:
                linaataustin Na Li
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: