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] Assigned: (DERBY-1909) ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
Date Tue, 26 Dec 2006 18:52:23 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1909?page=all ]

Bryan Pendleton reassigned DERBY-1909:
--------------------------------------

    Assignee: Bryan Pendleton

> ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
> -----------------------------------------------------------------
>
>                 Key: DERBY-1909
>                 URL: http://issues.apache.org/jira/browse/DERBY-1909
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: repro.sql
>
>
> 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:
> - 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: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message