Derby
  1. Derby
  2. DERBY-4272

SQL Authorization Support for dblook

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None
    • Environment:
      Any

      Description

      Currently dblook suffers from two major shortcomings.

      1. dblook doesn't take the object dependencies into consideration when generating DDL scripts
      2. dblook doesn't have any support for SQL authorization

      I intend to fix these two issues and improve dblook so that the DDL scripts generated by dblook can be executed without errors under all conditions.

      1. DERBY-4272-changes-u1.txt
        0.8 kB
        Hiranya Jayathilaka
      2. DERBY-4272-changes-u2.txt
        1 kB
        Hiranya Jayathilaka
      3. DERBY-4272-changes-u3.txt
        2 kB
        Hiranya Jayathilaka
      4. DERBY-4272-changes-u4.txt
        2 kB
        Hiranya Jayathilaka
      5. DERBY-4272-changes-u5.txt
        2 kB
        Hiranya Jayathilaka
      6. DERBY-4272-changes-u6.txt
        2 kB
        Hiranya Jayathilaka
      7. DERBY-4272-u1.patch
        46 kB
        Hiranya Jayathilaka
      8. DERBY-4272-u2.patch
        55 kB
        Hiranya Jayathilaka
      9. DERBY-4272-u3.patch
        91 kB
        Hiranya Jayathilaka
      10. DERBY-4272-u4.patch
        108 kB
        Hiranya Jayathilaka
      11. DERBY-4272-u5.patch
        108 kB
        Hiranya Jayathilaka
      12. DERBY-4272-u6.patch
        129 kB
        Hiranya Jayathilaka
      13. dhw-sample-1.sql
        2 kB
        Dag H. Wanvik
      14. new.sql
        6 kB
        Hiranya Jayathilaka
      15. old.sql
        4 kB
        Hiranya Jayathilaka

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12465832 ] Default workflow, editable Closed status [ 12799738 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Patch Available]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-4487 [ DERBY-4487 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-4485 [ DERBY-4485 ]
          Hiranya Jayathilaka made changes -
          Attachment DERBY-4272-u6.patch [ 12428049 ]
          Attachment DERBY-4272-changes-u6.txt [ 12428050 ]
          Hiranya Jayathilaka made changes -
          Attachment DERBY-4272-u5.patch [ 12417403 ]
          Attachment DERBY-4272-changes-u5.txt [ 12417404 ]
          Dag H. Wanvik made changes -
          Attachment dhw-sample-1.sql [ 12417288 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Patch Available]
          Hiranya Jayathilaka made changes -
          Attachment old.sql [ 12415944 ]
          Attachment new.sql [ 12415945 ]
          Hiranya Jayathilaka made changes -
          Attachment DERBY-4272-u4.patch [ 12415942 ]
          Attachment DERBY-4272-changes-u4.txt [ 12415943 ]
          Hiranya Jayathilaka made changes -
          Attachment DERBY-4272-u3.patch [ 12413309 ]
          Attachment DERBY-4272-changes-u3.txt [ 12413310 ]
          Dag H. Wanvik made changes -
          Assignee Hiranya Jayathilaka [ hiranya ]
          Hiranya Jayathilaka made changes -
          Attachment DERBY-4272-u2.patch [ 12411500 ]
          Attachment DERBY-4272-changes-u2.txt [ 12411501 ]
          Hiranya Jayathilaka made changes -
          Field Original Value New Value
          Attachment DERBY-4272-u1.patch [ 12410585 ]
          Attachment DERBY-4272-changes-u1.txt [ 12410586 ]
          Hiranya Jayathilaka created issue -

            People

            • Assignee:
              Hiranya Jayathilaka
              Reporter:
              Hiranya Jayathilaka
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development