[DERBY-4164] Make REVOKE statement description mention what happens for open result sets/cursors

• 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
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 16/Apr/09 17:22
• Updated: 05/Jul/10 17:12
• Resolved: 17/Apr/09 23:27

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.