Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1776550455.1245735307448.JavaMail.jira@brutus>
Date: Mon, 22 Jun 2009 22:35:07 -0700 (PDT)
From: "Eranda Sooriyabandara (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Assigned: (DERBY-1909) ALTER TABLE DROP COLUMN needs to
 update GRANTed column privileges
In-Reply-To: <10934491.1159649661404.JavaMail.root@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eranda Sooriyabandara reassigned DERBY-1909:
--------------------------------------------

    Assignee: Bryan Pendleton  (was: Eranda Sooriyabandara)

> ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
> -----------------------------------------------------------------
>
>                 Key: DERBY-1909
>                 URL: https://issues.apache.org/jira/browse/DERBY-1909
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.1.4
>            Reporter: Bryan Pendleton
>            Assignee: Bryan Pendleton
>             Fix For: 10.3.1.4
>
>         Attachments: d1909_partial_incomplete.diff, repro.sql, rewrite_syscolperms_v1.diff, rewrite_syscolperms_v1.stat, rewrite_syscolperms_v2.diff, rewrite_syscolperms_v3.diff
>
>
> When ALTER TABLE DROP COLUMN is used to drop a column from a table, it needs to update the GRANTed column privileges on that table.
> The following behaviors need to be provided:
> - DROP COLUMN needs to automatically revoke any privileges which have been granted on this column
> - Privileges which have been granted on other columns in this table need to be adjusted due to changed column position numbers
> When this problem is fixed, the following additional cleanup steps should occur:
> - The check that disables DROP COLUMN in sqlAuthorization mode needs to be removed
> - There is a comment in AlterTableConstantAction that needs to be revised
> - The tests in lang/altertableDropColumn.sql should be moved into altertable.sql
> - altertableDropColumn.sql and altertableDropColumn.out should be deleted
> Search for this JIRA issue number in the code to find the relevant places to change.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.