[DERBY-1611] A view should be dropped when a privilege required by the view is revoked.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Mamta A. Satoor
• Reporter: Mamta A. Satoor
• Created: 31/Jul/06 02:38
• Updated: 01/Jul/09 00:34
• Resolved: 30/Aug/06 06:20

Description

A view tracks its privileges requirements using Derby's Dependency Manager. If any one of those required privileges are revoked, the view should be dropped automatically.

I am just creating a new jira entry here so it is easier to track sub items of DERBY-1330. Will link this Jira entry to DERBY-1330.

See the functional spec attached to DERBY-1330

Issue Links

• incorporates: DERBY-1631 Derby needs to support drop view cascade in order for revoke privilege to function correctly
• is part of: DERBY-1330 Provide runtime privilege checking for grant/revoke functionality
• relates to: DERBY-1782 When a privilege is revoked at table level, Derby should only drop objects that require that particular privilege and not all the objects that require some form of privilege on that table.