Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-464 Enhance Derby by adding grant/revoke support. Grant/Revoke provide finner level of privileges than currently provided by Derby that is especially useful in network configurations.
  3. DERBY-1544

Address remaining upgrade task(s) to complete full upgrade mechanism for GRANT/REVOKE, specifically with changing database owner name from 'DBA' to authorizationId of user invoking upgrade.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.1.6
    • 10.2.1.6
    • SQL
    • None
    • generic
    • Normal

    Description

      Upgrading a database from 10.1 to 10.2 should automatically change database owner, recorded as owner of system schemas in sysschemas, from pseudo user 'DBA' to authorizationID of the user attempting upgrade.

      Another upgrade change I am thinking about is to grant execute privilege to 5 system routines that by default have execute privilege to public when a new database is created. Five system routines, two compress routines and three statistics related routines are given execute privilege to public when a new 10.2 database is created. This is not done when a 10.1 database is upgraded to 10.2 and probably good to include these privileges during database upgrade.

      Attachments

        1. d1544-patch1-draft.diff
          0.8 kB
          Deepa
        2. d1544-patch1-v1.diff
          4 kB
          Deepa
        3. d1544-patch1-v1.status
          0.4 kB
          Deepa
        4. d1544-patch2-v1.diff
          8 kB
          Deepa
        5. d1544-patch2-v1.status
          0.4 kB
          Deepa
        6. d1544-patch2-v2.diff
          8 kB
          Deepa

        Activity

          People

            deepa Deepa
            bandaram Satheesh E. Bandaram
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: