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

SQL roles: add catalog support

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.5.1.1
    • SQL
    • None
    • Security

    Description

      As a next step after adding support for the roles syntax, I intend to
      make a patch which implements catalog support for roles,
      cf. SYS.SYSROLES described in the specification (attached to
      DERBY-2207). Also the patch should tie this support up to the parser
      support, so the role statements can be executed. Any privileges
      granted to roles would still have no effect at run-time.

      Attachments

        1. DERBY-3137-uuid-2.diff
          0.6 kB
          Dag H. Wanvik
        2. DERBY-3137-uuid.stat
          0.7 kB
          Dag H. Wanvik
        3. DERBY-3137-uuid.diff
          20 kB
          Dag H. Wanvik
        4. DERBY-3137-setRoleNoDynamicNone.stat
          0.2 kB
          Dag H. Wanvik
        5. DERBY-3137-setRoleNoDynamicNone.diff
          3 kB
          Dag H. Wanvik
        6. DERBY-3137-setRoleNoCNF-3.stat
          0.6 kB
          Dag H. Wanvik
        7. DERBY-3137-setRoleNoCNF-3.diff
          10 kB
          Dag H. Wanvik
        8. DERBY-3137-setRoleNoCNF-2.stat
          0.6 kB
          Dag H. Wanvik
        9. DERBY-3137-setRoleNoCNF-2.diff
          10 kB
          Dag H. Wanvik
        10. DERBY-3137-setRoleNoCNF.stat
          0.5 kB
          Dag H. Wanvik
        11. DERBY-3137-setRoleNoCNF.stat
          0.5 kB
          Dag H. Wanvik
        12. DERBY-3137-setRoleNoCNF.diff
          9 kB
          Dag H. Wanvik
        13. DERBY-3137-setRoleNoCNF.diff
          8 kB
          Dag H. Wanvik
        14. DERBY-3137-setRoleAsStringFix-b.stat
          0.3 kB
          Dag H. Wanvik
        15. DERBY-3137-setRoleAsStringFix-b.diff
          9 kB
          Dag H. Wanvik
        16. DERBY-3137-setRoleAsStringFix.stat
          0.1 kB
          Dag H. Wanvik
        17. DERBY-3137-setRoleAsStringFix.diff
          3 kB
          Dag H. Wanvik
        18. DERBY-3137-rename-b.stat
          1 kB
          Dag H. Wanvik
        19. DERBY-3137-rename-b.diff
          37 kB
          Dag H. Wanvik
        20. DERBY-3137-rename.stat
          1 kB
          Dag H. Wanvik
        21. DERBY-3137-rename.stat
          1 kB
          Dag H. Wanvik
        22. DERBY-3137-rename.diff
          37 kB
          Dag H. Wanvik
        23. DERBY-3137-rename.diff
          38 kB
          Dag H. Wanvik
        24. DERBY-3137-moreTests-b.stat
          0.1 kB
          Dag H. Wanvik
        25. DERBY-3137-moreTests-b.diff
          3 kB
          Dag H. Wanvik
        26. DERBY-3137-moreTests.stat
          0.1 kB
          Dag H. Wanvik
        27. DERBY-3137-moreTests.diff
          3 kB
          Dag H. Wanvik
        28. DERBY-3137-ijfix.stat
          0.7 kB
          Dag H. Wanvik
        29. DERBY-3137-ijfix.stat
          0.6 kB
          Dag H. Wanvik
        30. DERBY-3137-ijfix.diff
          9 kB
          Dag H. Wanvik
        31. DERBY-3137-ijfix.diff
          9 kB
          Dag H. Wanvik
        32. DERBY-3137-current_role_type.stat
          0.2 kB
          Dag H. Wanvik
        33. DERBY-3137-current_role_type.diff
          2 kB
          Dag H. Wanvik
        34. DERBY-3137-2.txt
          15 kB
          Dag H. Wanvik
        35. DERBY-3137-2.stat
          3 kB
          Dag H. Wanvik
        36. DERBY-3137-2.diff
          161 kB
          Dag H. Wanvik
        37. DERBY-3137.txt
          15 kB
          Dag H. Wanvik
        38. DERBY-3137.stat
          3 kB
          Dag H. Wanvik
        39. DERBY-3137.diff
          161 kB
          Dag H. Wanvik
        40. DERBY-3137.diff
          161 kB
          Dag H. Wanvik

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2207 Improve usability of Derby's client/server security by implementing ANSI Roles

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3886 SQL roles: ij show enabled and settable roles

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dagw Dag H. Wanvik
              dagw Dag H. Wanvik
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: