You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <de...@db.apache.org> on 2006/02/22 01:23:38 UTC

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

Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER  support for routines(functions or procedures)
----------------------------------------------------------------------------------------------------------

         Key: DERBY-1023
         URL: http://issues.apache.org/jira/browse/DERBY-1023
     Project: Derby
        Type: Sub-task
  Components: SQL  
    Reporter: Mamta A. Satoor
     Fix For: 10.2.0.0


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. 
 


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


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

Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1023?page=all ]

Mamta A. Satoor updated DERBY-1023:
-----------------------------------

    Assign To:     (was: Mamta A. Satoor)

> Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER  support for routines(functions or procedures)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1023
>          URL: http://issues.apache.org/jira/browse/DERBY-1023
>      Project: Derby
>         Type: Sub-task

>   Components: SQL
>     Reporter: Mamta A. Satoor
>      Fix For: 10.2.0.0

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

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


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

Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1023?page=all ]

Satheesh Bandaram resolved DERBY-1023.
--------------------------------------

    Resolution: Won't Fix

Not part of the functional spec being targetted for 10.2 release. Might still be useful enhancement to Derby. If someone has itch to implement, please file a new JIRA entry.. not a sub-task of DERBY-464.

> Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER  support for routines(functions or procedures)
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1023
>                 URL: http://issues.apache.org/jira/browse/DERBY-1023
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Mamta A. Satoor
>             Fix For: 10.2.0.0
>
>
> 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. 
>  

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

        

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

Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1023?page=all ]

Satheesh Bandaram closed DERBY-1023.
------------------------------------


> Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER  support for routines(functions or procedures)
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1023
>                 URL: http://issues.apache.org/jira/browse/DERBY-1023
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Mamta A. Satoor
>             Fix For: 10.2.0.0
>
>
> 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. 
>  

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

        

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

Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1023?page=all ]

Mamta A. Satoor reassigned DERBY-1023:
--------------------------------------

    Assign To: Mamta A. Satoor

> Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER  support for routines(functions or procedures)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1023
>          URL: http://issues.apache.org/jira/browse/DERBY-1023
>      Project: Derby
>         Type: Sub-task
>   Components: SQL
>     Reporter: Mamta A. Satoor
>     Assignee: Mamta A. Satoor
>      Fix For: 10.2.0.0

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

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