Derby
  1. Derby
  2. DERBY-3884

dblook scripts will fail to correctly recreate objects which depend on creator privileges

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: None
    • Component/s: Tools
    • Urgency:
      Normal

      Description

      The dblook utility produces a script which can be used to recreate the schema of a database. Permissions are added in one big block at the end of this script. However, the faithful recreation of some objects (like views) may depend on the creator being a specific user having specific privileges. Faithfully recreating the schema may require the ability to change user and sort, by dependency, the statements which dblook emits--so that permission grants may be interleaved with object declarations. For a discussion of this problem, please see the commentary by Dag, dated 25/Sep/08, on DERBY-3877.

      This problem was introduced when we added GRANT/REVOKE to Derby. The addition of SQL Roles creates more problem cases.

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-3877 [ DERBY-3877 ]
          Kathey Marsden made changes -
          Component/s Tools [ 11414 ]
          Hide
          Kristian Waagan added a comment -

          Triaged July 3, 2009: Assigned normal urgency.

          Show
          Kristian Waagan added a comment - Triaged July 3, 2009: Assigned normal urgency.
          Kristian Waagan made changes -
          Urgency Normal
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Gavin made changes -
          Workflow jira [ 12442943 ] Default workflow, editable Closed status [ 12799485 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Development