Derby
  1. Derby
  2. DERBY-5350

Devguide needs update for definer's rights

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      I found the following in the Using SQL roles topic of the devguide:

      "Within stored procedures and functions that contain SQL, the current role is on the authorization stack. Initially, inside a nested connection, the current role is set to that of the calling context."
      http://db.apache.org/derby/docs/10.8/devguide/cdevcsecureroles.html

      I think this is only correct for procedures running with invoker's rights. For procedures running with definer's rights, no role is set initially, according to the CREATE PROCEDURE statement topic in the reference manual:

      "When the procedure is first invoked, no role is set; even if the invoker has set a current role, the procedure running with definer's rights has no current role set initially."
      http://db.apache.org/derby/docs/10.8/ref/rrefcreateprocedurestatement.html

      1. derby-5330a.diff
        2 kB
        Dag H. Wanvik
      2. cdevcsecureroles.html
        14 kB
        Dag H. Wanvik
      3. cdevcsecureroles.html
        14 kB
        Dag H. Wanvik
      4. derby-5350b.diff
        3 kB
        Dag H. Wanvik

        Activity

        Knut Anders Hatlen created issue -
        Dag H. Wanvik made changes -
        Field Original Value New Value
        Attachment derby-5330a.diff [ 12487714 ]
        Attachment cdevcsecureroles.html [ 12487715 ]
        Dag H. Wanvik made changes -
        Issue & fix info [Patch Available]
        Dag H. Wanvik made changes -
        Assignee Dag H. Wanvik [ dagw ]
        Dag H. Wanvik made changes -
        Attachment cdevcsecureroles.html [ 12487719 ]
        Attachment derby-5350b.diff [ 12487720 ]
        Dag H. Wanvik made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info [Patch Available]
        Resolution Fixed [ 1 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kathey Marsden made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Kathey Marsden made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Fix Version/s 10.8.1.6 [ 12316676 ]
        Fix Version/s 10.9.0.0 [ 12316344 ]
        Resolution Fixed [ 1 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Fix Version/s 10.8.1.6 [ 12316676 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.2 [ 12317968 ]
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Gavin made changes -
        Workflow jira [ 12621331 ] Default workflow, editable Closed status [ 12801212 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development