db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1909) ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
Date Sat, 06 Jan 2007 16:24:27 GMT

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

Bryan Pendleton commented on DERBY-1909:

Attached is rewrite_syscolperms_v2.diff. This patch proposal differs from
the v1 version only in that the code patch to DataDictionaryImpl.java
for DERBY-1847 has been removed from this patch.

This patch now applies cleanly against the head of trunk and is, I
believe, ready for commit. derbyall and suites.All pass with this patch.
Please review the patch as time permits.

> 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:
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: d1909_partial_incomplete.diff, repro.sql, rewrite_syscolperms_v1.diff,
rewrite_syscolperms_v1.stat, rewrite_syscolperms_v2.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.
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message