[DERBY-1023] Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER support for routines(functions or procedures)

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Mamta A. Satoor
• Created: 22/Feb/06 09:22
• Updated: 24/Jul/06 23:52
• Resolved: 24/Jul/06 23:52

Description

Derby parser supports EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER on a routine (function or procedure) but this information doesn't get saved anywhere.
eg from lang/grantRevoke.sql test
CREATE PROCEDURE AUTH_TEST.addUserUtility(IN userName VARCHAR(50), IN permission VARCHAR(22))
LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL SECURITY INVOKER
EXTERNAL NAME 'org.apache.derby.database.UserUtility.add ';

Finish up this functionality by doing necessary work required during compile, execute and upgrade times.