Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.5.1.1
    • Component/s: Tools
    • Labels:
      None

      Description

      dblook does have support for grant/revoke although I am unsure of its quality, cf, my questions
      in DERBY-3868. Nevertheless, I choose to build support for roles for dblook.
      Since role creation and the granting of roles is only allowed for the data base owner in the first basic
      roles implementation, expanding the existing dblook tests to just dump the roles and roles grants should be easy.

      In general though, the dblook output file, in order to receate a database, must potentially use several connection, so the objects will be owned by the original owner. [The model for running the presently generated script run seems to be within one connection.] Setting roles properly to be able to recreate a view with the correct owner, for example, would be part of such a more advanced script which would be object owner aware.

      My intention with this issue is just to add support for dumping roles and role grants.

        Attachments

        1. derby-3877-1.diff
          35 kB
          Dag H. Wanvik
        2. derby-3877-1.stat
          2 kB
          Dag H. Wanvik
        3. derby-3877-2.diff
          40 kB
          Dag H. Wanvik
        4. derby-3877-2.stat
          2 kB
          Dag H. Wanvik

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: