[ 
http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12421188 ] 
            
Daniel John Debrunner commented on DERBY-1489:
----------------------------------------------

Bryan wrote:
----
2) DROP COLUMN needs to automatically revoke any privileges granted on the 
column. We need some code in the dropColumnFromTable() method in 
AlterTableConstantAction which looks for privileges granted on this column, and 
if there are any, automatically revoke those privileges. 
----
That should also be driven by the dependency system. A grant privilege on a 
column should be dependent on the column.
When the column is dropped it fires off a invalidation event  and the privilege 
should drop itself .




> Provide ALTER TABLE DROP COLUMN functionality
> ---------------------------------------------
>
>                 Key: DERBY-1489
>                 URL: http://issues.apache.org/jira/browse/DERBY-1489
>             Project: Derby
>          Issue Type: New Feature
>          Components: Documentation, SQL
>    Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.1, 
> 10.1.3.0, 10.1.3.1
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>             Fix For: 10.2.0.0
>
>         Attachments: dropColumn_2.diff
>
>
> Provide a way to drop a column from an existing table. Possible syntax would 
> be:
>   ALTER TABLE tablename DROP COLUMN columnname CASCADE / RESTRICT;
> Feature should properly handle columns which are used in constraints, views, 
> triggers, indexes, etc.

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

        

Reply via email to