[ http://issues.apache.org/jira/browse/DERBY-1909?page=all ]
Bryan Pendleton updated DERBY-1909:
-----------------------------------
Description:
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.
was:
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.
> 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
