Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4164

Make REVOKE statement description mention what happens for open result sets/cursors

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.2.1, 10.3.3.1, 10.4.2.1, 10.5.1.1
    • Fix Version/s: 10.5.2.0, 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      When a REVOKE statement is executed, already open result sets are not impacted. This should be mentioned
      in the user documentation, at least here: ref/rrefsqljrevoke.html.

      Permissions are checked at statement execute time; if this succeeds, a cursor/result set will be able to access all rows
      in the result set even if privileges/roles are revoked after the execute but before the result set/cursor is closed.

        Attachments

        1. derby-4164.diff
          1 kB
          Dag H. Wanvik
        2. derby-4164-2.diff
          1 kB
          Camilla Haase
        3. derby-4164-3.diff
          1 kB
          Dag H. Wanvik
        4. derby-4164-4.diff
          1 kB
          Dag H. Wanvik
        5. rrefsqljrevoke.html
          20 kB
          Camilla Haase
        6. rrefsqljrevoke-3.html
          20 kB
          Dag H. Wanvik
        7. rrefsqljrevoke-4.html
          20 kB
          Dag H. Wanvik

          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: