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

        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: