Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2264

Restrict shutdown, upgrade, and encryption powers to the database owner

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.3.1.4
    • SQL
    • None
    • Release Note Needed
    • Security

    Description

      This JIRA separates out the database-owner powers from the system privileges in the master security JIRA DERBY-2109. Restrict the following powers to the database owner for the moment: shutdown, upgrade, and encryption.

      Attachments

        1. releaseNote.html
          4 kB
          Dag H. Wanvik
        2. releaseNote.html
          5 kB
          Dag H. Wanvik
        3. releaseNote.html
          6 kB
          Richard N. Hillegas
        4. releaseNote.html
          6 kB
          Myrna van Lunteren
        5. extra-tests.tar.gz
          3 kB
          Dag H. Wanvik
        6. encrypt-3.sql
          1 kB
          Dag H. Wanvik
        7. encrypt-2.sql
          1.0 kB
          Dag H. Wanvik
        8. encrypt-1b.sql
          1 kB
          Dag H. Wanvik
        9. DERBY-2264-9.stat
          0.4 kB
          Dag H. Wanvik
        10. DERBY-2264-9.diff
          13 kB
          Dag H. Wanvik
        11. DERBY-2264-9.diff
          14 kB
          Dag H. Wanvik
        12. DERBY-2264-8.stat
          0.2 kB
          Dag H. Wanvik
        13. DERBY-2264-8.stat
          0.2 kB
          Dag H. Wanvik
        14. DERBY-2264-8.diff
          4 kB
          Dag H. Wanvik
        15. DERBY-2264-8.diff
          9 kB
          Dag H. Wanvik
        16. DERBY-2264-7.stat
          0.3 kB
          Dag H. Wanvik
        17. DERBY-2264-7.diff
          17 kB
          Dag H. Wanvik
        18. DERBY-2264-6b.stat
          0.2 kB
          Dag H. Wanvik
        19. DERBY-2264-6b.diff
          2 kB
          Dag H. Wanvik
        20. DERBY-2264-6.stat
          0.2 kB
          Dag H. Wanvik
        21. DERBY-2264-6.diff
          1 kB
          Dag H. Wanvik
        22. DERBY-2264-5.stat
          0.6 kB
          Dag H. Wanvik
        23. DERBY-2264-5.diff
          38 kB
          Dag H. Wanvik
        24. DERBY-2264-4.stat
          0.5 kB
          Dag H. Wanvik
        25. DERBY-2264-4.diff
          37 kB
          Dag H. Wanvik
        26. DERBY-2264-3.stat
          0.4 kB
          Dag H. Wanvik
        27. DERBY-2264-3.diff
          4 kB
          Dag H. Wanvik
        28. DERBY-2264-2.stat
          0.4 kB
          Dag H. Wanvik
        29. DERBY-2264-2.diff
          10 kB
          Dag H. Wanvik
        30. DERBY-2264-1.stat
          2 kB
          Dag H. Wanvik
        31. DERBY-2264-1.diff
          71 kB
          Dag H. Wanvik
        32. dbaPowers.html
          10 kB
          Richard N. Hillegas
        33. dbaPowers.html
          11 kB
          Richard N. Hillegas
        34. dbaPowers.html
          12 kB
          Richard N. Hillegas

        Issue Links

          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2520 Document new restrictions of database shutdown, encryption and hard upgrade powers

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2451 a client can crash connections of another client

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2109 System privileges

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2470 No authentication required to restore a backup

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3038 SYSCS_IMPORT_TABLE FAILS with No current connection after shutdown/reconnect to encrypted database : 10.3.1.4 regression

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2728 Make DBO restrictions from Derby-2264 optional for upgrades

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dagw Dag H. Wanvik
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: