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

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

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

        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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment