[ http://issues.apache.org/jira/browse/DERBY-1909?page=all ]
Bryan Pendleton updated DERBY-1909:
-----------------------------------
Attachment: repro.sql
repro.sql is a first start at a script demonstrating the problem
> 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:
> - 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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
