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

SQL Authorization Support for dblook

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Tools
    • None
    • 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.

      Attachments

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

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4485 Add dblook support for UDTs.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4487 Add dblook support for SEQUENCEs

          • Major - Major loss of function.
          • Closed

          Activity

            People

              hiranya Hiranya Kasub Jayathilaka
              hiranya Hiranya Kasub Jayathilaka
              Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: