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

          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.

            People

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

              Dates

              • Created:
                Updated:

                Development