[
https://issues.apache.org/jira/browse/DERBY-6434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-6434:
---------------------------------
Attachment: derby-6434-05-aa-selectDrivenInserts.diff
Attaching derby-6434-05-aa-selectDrivenInserts.diff. This patch removes
privilege checks for user-defined types encountered while binding SELECTs. A
special exception is made for explicit CASTs to user-defined types. Those CASTs
should require that the user enjoy USAGE privilege on the target types. I am
running tests now.
Touches the following files:
---------------
M java/engine/org/apache/derby/impl/sql/compile/SelectNode.java
Disable UDT privilege checks when binding SELECTs.
---------------
M java/engine/org/apache/derby/impl/sql/compile/CastNode.java
M java/engine/org/apache/derby/impl/sql/compile/QueryTreeNode.java
But retain UDT privilege checks for explicit CASTs.
---------------
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java
Tests for this behavior change.
> Incorrect privileges may be required for INSERT and DELETE statements.
> ----------------------------------------------------------------------
>
> Key: DERBY-6434
> URL: https://issues.apache.org/jira/browse/DERBY-6434
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.11.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Labels: derby_backport_reject_10_10
> Fix For: 10.11.0.0
>
> Attachments: derby-6434-01-aa-correctInsertPrivs.diff,
> derby-6434-01-ac-correctInsertPrivs.diff,
> derby-6434-02-ac-correctDeletePrivs.diff,
> derby-6434-03-ac-testCaseForDerby-6432.diff,
> derby-6434-04-aa-dontNeedPrivOnGeneratedColumnTypeForInsert.diff,
> derby-6434-05-aa-selectDrivenInserts.diff, releaseNote.html
>
>
> This issue is a place to address problems with INSERT and DELETE statements
> similar to the problems affecting UPDATE statements recorded on DERBY-6429.
> In particular, DERBY-6432 and DERBY-6433 list some of the problems with
> INSERT statements.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
