db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6434) Incorrect privileges may be required for INSERT and DELETE statements.
Date Mon, 03 Mar 2014 16:47:23 GMT

     [ 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:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>              Labels: derby_backport_reject_10_10
>             Fix For:
>         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

View raw message