[DERBY-1579] Remove SYS.SYSREQUIREDPERM from Derby 10.2. This was added for Grant Revoke functionality

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Urgency: Urgent
• Assignee: Yip Ng
• Reporter: Mamta A. Satoor
• Created: 24/Jul/06 06:57
• Updated: 13/Dec/07 09:05
• Resolved: 09/Aug/06 20:46

Description

With the Grant Revoke functionality. Derby engine needs to keep track of view/constraint/trigger's dependencies on various privileges. SYS.SYSREQUIREDPERM table was added for this purpose. But these depdencies can be mantained using the existing Dependency Manager. I have done quite a bit of work using Dependency Manager for Grant Revoke and do not see a need for SYS.SYSREQUIREDPERM. Before 10.2 release, we should drop SYS.SYSREQUIREDPERM from the Derby code and update the Grant/Revoke functional spec accordingly.

Issue Links

• is part of: DERBY-1330 Provide runtime privilege checking for grant/revoke functionality
• is part of: DERBY-464 Enhance Derby by adding grant/revoke support. Grant/Revoke provide finner level of privileges than currently provided by Derby that is especially useful in network configurations.