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

Transfer database owner drops table owner

    Details

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

      Description

      1) What is the problem?
      When changing owner of a database, the owners of all tables belonging to this database are removed.

      2) For example:
      2.1) user_A is owner of DB1, user_B is owner of DB1.TABLE1, and user_D is owner of DB1.TABLE2.
      2.2) admin with" ALL with grant option" changes the owner of DB1 from user_A to user_C through command "ALTER DATABASE DB1 SET OWNER USER user_C".
      2.3) Now, user_C is owner of DB1, there is no owner on DB1.TABLE1, and no owner on DB1.TABLE2.. In other words, the owners of DB1.TABLE1 and DB1.TABLE2 are removed when changing owner of their database.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                LinaAtAustin Na Li
                Reporter:
                LinaAtAustin Na Li
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: