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

Table Rename Cross Database should update permission correctly

    XMLWordPrintableJSON

Details

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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SENTRY-2368 Alter table rename across databases is not persisted correctly

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link Review Link for this case

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: