Derby
  1. Derby
  2. DERBY-2264

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      Release Note Needed
    • Bug behavior facts:
      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.

      1. releaseNote.html
        4 kB
        Dag H. Wanvik
      2. releaseNote.html
        5 kB
        Dag H. Wanvik
      3. releaseNote.html
        6 kB
        Rick 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
        Rick Hillegas
      33. dbaPowers.html
        11 kB
        Rick Hillegas
      34. dbaPowers.html
        12 kB
        Rick Hillegas

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12394812 ] Default workflow, editable Closed status [ 12798585 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Release Note Needed, Existing Application Impact] [Release Note Needed]
          Dag H. Wanvik made changes -
          Component/s Security [ 11411 ]
          Dag H. Wanvik made changes -
          Derby Categories [Security]
          Dag H. Wanvik made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Link This issue relates to DERBY-3038 [ DERBY-3038 ]
          Myrna van Lunteren made changes -
          Attachment releaseNote.html [ 12361337 ]
          Bernt M. Johnsen made changes -
          Link This issue is related to DERBY-2451 [ DERBY-2451 ]
          Rick Hillegas made changes -
          Attachment dbaPowers.html [ 12360820 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12359932 ]
          Dag H. Wanvik made changes -
          Attachment extra-tests.tar.gz [ 12359439 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12359305 ]
          Dag H. Wanvik made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Release Note Needed, Existing Application Impact, Patch Available] [Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-9.diff [ 12359236 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-9.diff [ 12359188 ]
          Attachment DERBY-2264-9.stat [ 12359189 ]
          Myrna van Lunteren made changes -
          Derby Info [Release Note Needed, Existing Application Impact, Patch Available] [Patch Available, Existing Application Impact, Release Note Needed]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Dag H. Wanvik made changes -
          Derby Info [Existing Application Impact, Release Note Needed] [Patch Available, Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-8.stat [ 12358640 ]
          Attachment DERBY-2264-8.diff [ 12358639 ]
          Dag H. Wanvik made changes -
          Link This issue relates to DERBY-2728 [ DERBY-2728 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-8.stat [ 12358577 ]
          Attachment DERBY-2264-8.diff [ 12358576 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12358427 ]
          Dag H. Wanvik made changes -
          Derby Info [Release Note Needed, Existing Application Impact, Patch Available] [Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Link This issue is blocked by DERBY-2520 [ DERBY-2520 ]
          Dag H. Wanvik made changes -
          Derby Info [Release Note Needed, Existing Application Impact] [Patch Available, Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-7.diff [ 12354869 ]
          Attachment DERBY-2264-7.stat [ 12354870 ]
          Dag H. Wanvik made changes -
          Derby Info [Release Note Needed, Existing Application Impact, Patch Available] [Existing Application Impact, Release Note Needed]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-2470 [ DERBY-2470 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-6b.diff [ 12353917 ]
          Attachment DERBY-2264-6b.stat [ 12353918 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-6.stat [ 12353555 ]
          Attachment DERBY-2264-6.diff [ 12353554 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-5.diff [ 12353288 ]
          Attachment DERBY-2264-5.stat [ 12353289 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-4.stat [ 12352799 ]
          Attachment DERBY-2264-4.diff [ 12352798 ]
          Dag H. Wanvik made changes -
          Derby Info [Release Note Needed, Existing Application Impact] [Patch Available, Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-3.stat [ 12352642 ]
          Attachment DERBY-2264-3.diff [ 12352641 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-3.stat [ 12352640 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-3.diff [ 12352639 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-3.stat [ 12352640 ]
          Attachment DERBY-2264-3.diff [ 12352639 ]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-2.diff [ 12351821 ]
          Attachment DERBY-2264-2.stat [ 12351822 ]
          Rick Hillegas made changes -
          Derby Info [Release Note Needed, Existing Application Impact, Patch Available] [Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment encrypt-1b.sql [ 12351702 ]
          Attachment encrypt-3.sql [ 12351704 ]
          Attachment encrypt-2.sql [ 12351703 ]
          Dag H. Wanvik made changes -
          Derby Info [Existing Application Impact] [Patch Available, Existing Application Impact, Release Note Needed]
          Dag H. Wanvik made changes -
          Attachment DERBY-2264-1.diff [ 12351625 ]
          Attachment DERBY-2264-1.stat [ 12351624 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Rick Hillegas made changes -
          Attachment dbaPowers.html [ 12350161 ]
          Andrew McIntyre made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Daniel John Debrunner made changes -
          Derby Info [Existing Application Impact]
          Rick Hillegas made changes -
          Attachment dbaPowers.html [ 12349451 ]
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-2109 [ DERBY-2109 ]
          Rick Hillegas created issue -

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development