db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1909) ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
Date Sat, 30 Sep 2006 20:54:21 GMT
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:
            Reporter: Bryan Pendleton

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
- 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


View raw message