Make REVOKE statement description mention what happens for open result
sets/cursors
-----------------------------------------------------------------------------------
Key: DERBY-4164
URL: https://issues.apache.org/jira/browse/DERBY-4164
Project: Derby
Issue Type: Improvement
Components: Documentation
Reporter: Dag H. Wanvik
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.