Derby
  1. Derby
  2. DERBY-5747

Native user authentication: Docs do not describe what happens to schema and its SQL objects on SYSCS_UTIL.SYSCS_DROP_USER call

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation, Services
    • Labels:
      None

      Description

      Currently, the schema and the objects remain after the user is dropped, cf. repro2.sh attached.
      The authorization id of the schema of the dropped user is still that id (dangling) after DROP.
      Perhaps ownership should revert to the DBO when a user is dropped, or should DROP USER do a cascade delete?
      There is no way currently to change the ownership of the schema to another user.
      At the very least we should document what happens.

      1. rrefnativedropuserproc.html
        5 kB
        Kim Haase
      2. repro2.sh
        0.7 kB
        Dag H. Wanvik
      3. DERBY-5747.diff
        0.9 kB
        Kim Haase

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12666246 ] Default workflow, editable Closed status [ 12797054 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info Patch Available [ 10102 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Issue & fix info Patch Available [ 10102 ]
          Kim Haase made changes -
          Attachment DERBY-5747.diff [ 12526531 ]
          Attachment rrefnativedropuserproc.html [ 12526532 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-866 [ DERBY-866 ]
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Attachment repro2.sh [ 12525837 ]
          Dag H. Wanvik created issue -

            People

            • Assignee:
              Kim Haase
              Reporter:
              Dag H. Wanvik
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development